Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Refresh Question
I have a pivot table that pulls from an outside data source, when you
open up the file it always asks you if you want to "ENABLE AUTOMATIC REFRESH". Is there any way to code this so it will automatically refresh without asking the user? Maybe by setting up an on open macro that would select the option to refresh for the user. Thanks, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Refresh Question
Sub Workbooks_Open
Application.DisplayAlerts = False ActiveSheet.PivotTables("YourPivotTableName").Pivo tCache.Refresh Application.DisplayAlerts = True End Sub Or, change ActiveSheet to Sheets("YourPivotTableSheet") Regards, Alan "smonczka" wrote in message ups.com... I have a pivot table that pulls from an outside data source, when you open up the file it always asks you if you want to "ENABLE AUTOMATIC REFRESH". Is there any way to code this so it will automatically refresh without asking the user? Maybe by setting up an on open macro that would select the option to refresh for the user. Thanks, Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Refresh Question
The 'enable automatic refresh' message can supressed by making registry
changes. http://support.microsoft.com/kb/248204 "smonczka" wrote: I have a pivot table that pulls from an outside data source, when you open up the file it always asks you if you want to "ENABLE AUTOMATIC REFRESH". Is there any way to code this so it will automatically refresh without asking the user? Maybe by setting up an on open macro that would select the option to refresh for the user. Thanks, Steve |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Refresh Question
Suppressing the notification for this sheet would work best...
Thanks to you both for your help. This was exactly what I needed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
Automatic Refresh | Excel Discussion (Misc queries) | |||
'Enable Automatic Refresh?' | Setting up and Configuration of Excel | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming |