Prev: Scrollbar
Next: Run time error 35788
From: smonczka on 1 Mar 2007 13:15
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

From: Alan on 1 Mar 2007 13:54
Sub Workbooks_Open
Application.DisplayAlerts = False
ActiveSheet.PivotTables("YourPivotTableName").PivotCache.Refresh
Application.DisplayAlerts = True
End Sub

Or, change ActiveSheet to Sheets("YourPivotTableSheet")

Regards,

Alan


"smonczka" <smonczka(a)gmail.com> wrote in message
news:1172772901.951826.216880(a)31g2000cwt.googlegroups.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
>


From: Vergel Adriano on 1 Mar 2007 14:01
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
>
>
From: smonczka on 2 Mar 2007 09:29
Suppressing the notification for this sheet would work best...

Thanks to you both for your help. This was exactly what I needed.

 | 
Pages: 1
Prev: Scrollbar
Next: Run time error 35788