Prev: date format error in cell
Next: How do I create a travel expense report by employee, by campus, b.
From: Eric on 23 Mar 2010 11:50
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!!
From: Roger Govier on 23 Mar 2010 13:50
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!!
From: Eric on 23 Mar 2010 19:55
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!!
> .
>
From: Ashish Mathur on 23 Mar 2010 21:13
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" <Eric(a)discussions.microsoft.com> wrote in message
news:72B34E5F-7673-4FE1-9F3E-C365D31D80C8(a)microsoft.com...
> 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!!

From: Roger Govier on 24 Mar 2010 05:47
Hi Eric

For XL2003
View>Toolbars>Forms>click the button icon>click 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 button>Excel Options>click Show Developer tab
From Developer tab>Controls section>Insert>Form Controls>Button and
proceed as for XL2003

Alternatively in XL2007>insert Tab>Illustrations>Shapes>choose 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!!
>> .
>>
 |  Next  |  Last
Pages: 1 2
Prev: date format error in cell
Next: How do I create a travel expense report by employee, by campus, b.