+ Reply to Thread
Results 1 to 3 of 3

how to update pivot table when new rows/columns are added to the original data?

  1. #1
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2010 (office) 2013 (home)
    Posts
    255

    how to update pivot table when new rows/columns are added to the original data?

    Hi,

    Anyone know how to update pivot table when new rows/columns are added to its original data without redoing the whole thing again?

    Thanks

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: how to update pivot table when new rows/columns are added to the original data?

    First, create a Dynamic Named Range and use that as your Source for the PT (see link in sig. for info on DNR's)

    Then, add a Worksheet_Change event and refresh the PT as and when.

    (You need to be careful if your PT has grouping in action)

  3. #3
    Registered User
    Join Date
    08-18-2009
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: how to update pivot table when new rows/columns are added to the original data?

    When I add information to a data table linked to a pivot table, I copy the data and insert the rows at the top.

    Then simply go to your pivot table and click "refresh".

    You can also go to pivot table, options, change data source, and enter new range.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1