| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling refresh data changed PivotTable prompt
I have an Excel 2000 workbook that contains multiple
PivotTables. When I refresh the data using "Refresh All" on the External Data toolbar, I get the following prompt multiple times: "The Refresh Data operation changed the PivotTable report." Can I disable this prompt so I don't have to acknowledge each one before Excel will proceed? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable auto-refresh with external data | Excel Worksheet Functions | |||
| Refresh Pivottable last 4 weeks data from today | Excel Worksheet Functions | |||
| Refresh existing data when changed in data validation list | New Users to Excel | |||
| Retain PivotTable formatting after "Refresh Data" | Excel Discussion (Misc queries) | |||
| Disabling external data refresh using vba | Excel Programming | |||
Linear Mode
