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

**mingali** · 11-03-2009, 11:09 AM

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

**DonkeyOte** · 11-03-2009, 11:27 AM

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)

**bluerog** · 11-03-2009, 03:30 PM

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.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions