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!!
|