ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disabling refresh data changed PivotTable prompt (https://www.excelbanter.com/excel-programming/295579-disabling-refresh-data-changed-pivottable-prompt.html)

dan

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.



All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com