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

    Unanswered: Updating and refreshing pivot table from VBA

    I have an existing pivot table. The pivot table is on one worksheet and the data for the pivot table is on another worksheet. As the data changes (number of rows changes) I would like to beable to tell the pivot table the data has changed and to refresh the pivot table. I would like to do all of this from VBA. This seems conceptionally really easy but I can not find any example code. Thanks for your help.

  2. #2
    Join Date
    Oct 2003
    Howdy and welcome to the board.

    Is the size of your original data changing (i.e. more columns or rows)?
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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