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.