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
|
|||
|
|||
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
|
|||
|
|||
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 |