Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Refresh
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!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Refresh
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!! . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Refresh
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!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Refresh
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!! . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Refresh? | Excel Discussion (Misc queries) | |||
slow document / pivot table refresh and pivot function | Excel Discussion (Misc queries) | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Pivot Table Refresh | Excel Worksheet Functions | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions |