PC Review


Reply
Thread Tools Rate Thread

Automatic Refresh Question

 
 
smonczka
Guest
Posts: n/a
 
      1st Mar 2007
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

 
Reply With Quote
 
 
 
 
Alan
Guest
Posts: n/a
 
      1st Mar 2007
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>



 
Reply With Quote
 
=?Utf-8?B?VmVyZ2VsIEFkcmlhbm8=?=
Guest
Posts: n/a
 
      1st Mar 2007
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
>
>

 
Reply With Quote
 
smonczka
Guest
Posts: n/a
 
      2nd Mar 2007
Suppressing the notification for this sheet would work best...

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic Refresh Colin Hammond Microsoft Access 2 1st Feb 2008 11:51 PM
How can I 'Enable Automatic Refresh' for Query Refresh by default =?Utf-8?B?QW5hbmQgRGVzaHBhbmRl?= Microsoft Excel Setup 0 10th Dec 2006 04:47 AM
Query Refresh-Enable Automatic Refresh Dialogue Box =?Utf-8?B?VGVycmk=?= Microsoft Excel Misc 0 6th May 2005 08:21 PM
Timing of automatic query refresh and macro pivot table refresh =?Utf-8?B?ZHV0dHk=?= Microsoft Excel Programming 2 1st Dec 2004 07:19 PM
Problem with refresh button breaking automatic refresh brian lanning Microsoft ASP .NET 0 29th Jul 2003 08:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:05 PM.