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?

Pivot table refresh on open
 

You can change the QuerySecurity setting in the Windows Registry, as
described he

http://support.microsoft.com/default.aspx?id=248204

If you use a zero for the setting, you should see the prompt.

Note the article's warning about backing up the registry before you
modify it.


FA wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html