View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FA FA is offline
external usenet poster
 
Posts: 18
Default Pivot table refresh on open

I have a report with several pivot tables. The pivot tables are set to
refresh on open. Usually when I open the reports the program would ask if I
wanted to refresh these.

I had a change in computer and now the pivot tables refresh on open without
asking.

How can I undo that in order to be like it used to be?