| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
| Pivot table won't refresh after external data update on open | Excel Programming | |||
| Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Linear Mode
