Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Refresh all pivot tables at once macro (Excel 2003/2000)

    I have developed a master workbook for my group that contains a number of pivot tables. I would like to give them one clickable control to referesh all pivot tables within the workbook at once, instead of having to manually refresh them one-by-one. Would one have to do a looping macro to page through the worksheets or is there an overall way to go about this? Thanks!

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Refresh all pivot tables at once macro (Excel 2003/2000)

    ActiveWorkbook.RefreshAll
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •