ExcelBanter - How can I refresh data in pivot tables lcoated in separate tabs?

It all went smoothly until I invoked the command. It seems to want to import
a text file. I am in Excel 2003. Any thoughts?

"Jim Thomlinson" wrote:

Sorry it is a macro so if it was me here is what I would do...

On a sheet add a button from the control toolbox (not the forms toolbar).
Right click the button and Change the name to cmdRefreshAll and change the
Caption to Refresh All and put an R in the Accelerator. Now close the
properties window. Double click the button and it will take you into the vbe
where you will see a bit of code like this...

Private Sub cmdRefreshAll_Click()

End Sub

Add that line I posted so you end up with this

Private Sub cmdRefreshAll_Click()
ThisWorkbook.RefreshAll
End Sub

Close the VBE. Take the spread sheet out of design mode by clicking on the
Triangle/Ruler/Pencil icon. You are good to go. Click the button and
everyting will get refreshed.

--
HTH...

Jim Thomlinson

"DavidG" wrote:

I am not understanding how to execute this. Could you be more specific?

"Jim Thomlinson" wrote:

If you want all pivot tables to be refreshed then

ThisWorkbook.RefreshAll

If you only want specific tables refreshed then it gets trickier...
--
HTH...

Jim Thomlinson

"DavidG" wrote:

I have one data table and have numerous worksheet tabs for each pivot table
accessing the table. I would like a way to refresh all of the pivot tables
without having to go into each tab refreshing the associated pivot table.
Any thoughts?