|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 27th, 2004, 12:58 PM
|
|||
|
|||
Pivot Tables from imported external data
Hi,
I have a macro which refreshes 5 pivot tables, one after another. However, when a pivot tables data changes slightly, a message appears.."The refresh data operation changed the pivot table report". How can i stop this message from appearing everytime the data in the pivot changes? Please help......JJ --- Message posted from http://www.ExcelForum.com/ 
|
|
#2
July 28th, 2004, 03:37 PM
|
|||
|
|||
|
Pivot Tables from imported external data
Try
Code: -------------------- Application.DisplayAlerts = False -------------------- don't forget to set back to True. --- Message posted from http://www.ExcelForum.com/
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change Pivot Table Data Source | Joe S. | General Discussion | 2 | June 22nd, 2004 02:50 PM |
| Pivot tables - get external data | MTBer | General Discussion | 0 | June 19th, 2004 06:36 AM |
| External Data refresh query | BeSmart | Worksheet Functions | 0 | April 30th, 2004 10:26 PM |
| source data updating for exsisting graphs or pivot tables | hegemon | Worksheet Functions | 0 | April 14th, 2004 05:16 PM |
| Date Formatting in Pivot tables | Don Niall | Worksheet Functions | 2 | October 17th, 2003 06:13 PM |
Linear Mode
