Disabling refresh data changed PivotTable prompt

D

Dan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot tables not refreshing after data source update 1
ODBC PivotTable Error 1
Change SourceName on Pivot Table 0
ODBC PivotTable Error 0
ODBC Driver Error in PivotTable 0
PivotTable with Server Page Field Leaves MS Query Application WindowOpen After Refresh. 0
Pivottable refresh problem 2
this action will cancel a pending refresh data command 2

Top