Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Refresh pivot on start-up

    How do I automatically refresh my Pivot Table, when I open the Excel document?

    I'm using Microsoft Excel 2002

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,

    Right click on the pivot table and choose Table Options.
    In the data options area in the bottom left hand corner of the form, tick the "Refresh On Open" checkbox.

    Hope that helps...

Posting Permissions

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