Pivot Table Refresh

I believe there is a way to create a button to refresh multiple pivot tables
within the same file, but I can't seem to figure it out.

I'm creating a model and would like less sophisticated users to be able to
use it. I would therefore like to create a simple button to refresh all
pivot tables on the first sheet of the workbook.

Any help is greatly appreciated!!

Hi Eric

Add the following code to a button on your page

Sub RefreshAll()
ActiveWorkbook.RefreshAll

End Sub

--
Regards
Roger Govier

Eric wrote:
I believe there is a way to create a button to refresh multiple pivot tables
within the same file, but I can't seem to figure it out.

I'm creating a model and would like less sophisticated users to be able to
use it. I would therefore like to create a simple button to refresh all
pivot tables on the first sheet of the workbook.

Any help is greatly appreciated!!

Roger,

Thanks much for your response. I'm guessing it will work once I figure out
how to add code to a button.

Again, any help is greatly appreciated.


"Roger Govier" wrote:

Hi Eric

Add the following code to a button on your page

Sub RefreshAll()
ActiveWorkbook.RefreshAll

End Sub

--
Regards
Roger Govier

Eric wrote:
I believe there is a way to create a button to refresh multiple pivot tables
within the same file, but I can't seem to figure it out.

I'm creating a model and would like less sophisticated users to be able to
use it. I would therefore like to create a simple button to refresh all
pivot tables on the first sheet of the workbook.

Any help is greatly appreciated!!
.

Hi,

In Excel 2007, there is a button to "Refresh All" under Pivot Table Tools
Options. When you click on that button, all pivot tables should update.
Not sure of whether there is a "Refresh all" in Excel 2003

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Eric" wrote in message
...
I believe there is a way to create a button to refresh multiple pivot
tables
within the same file, but I can't seem to figure it out.

I'm creating a model and would like less sophisticated users to be able to
use it. I would therefore like to create a simple button to refresh all
pivot tables on the first sheet of the workbook.

Any help is greatly appreciated!!

Hi Eric

For XL2003
ViewToolbarsFormsclick the button iconclick a location on your sheet
and drag to the size you want.
You will then be asked what macro you want to add, point to the macro
provided and click OK.

You can change the text of the Button to what you want, by right
clicking on the button, and you can drag it to any position on the
screen that you wish.

For XL2007
You need to have the Developer tab switched on
Click Round Office buttonExcel Optionsclick Show Developer tab
From Developer tabControls sectionInsertForm ControlsButton and
proceed as for XL2003

Alternatively in XL2007insert TabIllustrationsShapeschoose a shape.
Right click on shape and you will see an option to Add macro.

--
Regards
Roger Govier

Eric wrote:
Roger,

Thanks much for your response. I'm guessing it will work once I figure out
how to add code to a button.

Again, any help is greatly appreciated.


"Roger Govier" wrote:

Hi Eric

Add the following code to a button on your page

Sub RefreshAll()
ActiveWorkbook.RefreshAll

End Sub

--
Regards
Roger Govier

Eric wrote:
I believe there is a way to create a button to refresh multiple pivot tables
within the same file, but I can't seem to figure it out.

I'm creating a model and would like less sophisticated users to be able to
use it. I would therefore like to create a simple button to refresh all
pivot tables on the first sheet of the workbook.

Any help is greatly appreciated!!
.

Thanks again Roger. That worked perfectly.



"Roger Govier" wrote:

Hi Eric

For XL2003
ViewToolbarsFormsclick the button iconclick a location on your sheet
and drag to the size you want.
You will then be asked what macro you want to add, point to the macro
provided and click OK.

You can change the text of the Button to what you want, by right
clicking on the button, and you can drag it to any position on the
screen that you wish.

For XL2007
You need to have the Developer tab switched on
Click Round Office buttonExcel Optionsclick Show Developer tab
From Developer tabControls sectionInsertForm ControlsButton and
proceed as for XL2003

Alternatively in XL2007insert TabIllustrationsShapeschoose a shape.
Right click on shape and you will see an option to Add macro.

--
Regards
Roger Govier

Eric wrote:
Roger,

Thanks much for your response. I'm guessing it will work once I figure out
how to add code to a button.

Again, any help is greatly appreciated.


"Roger Govier" wrote:

Hi Eric

Add the following code to a button on your page

Sub RefreshAll()
ActiveWorkbook.RefreshAll

End Sub

--
Regards
Roger Govier

Eric wrote:
I believe there is a way to create a button to refresh multiple pivot tables
within the same file, but I can't seem to figure it out.

I'm creating a model and would like less sophisticated users to be able to
use it. I would therefore like to create a simple button to refresh all
pivot tables on the first sheet of the workbook.

Any help is greatly appreciated!!
.

.