View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
 
Posts: 376
Default 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!!