Pivot Table Refresh
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!!
.
.
|