Pivot Table - Auto Update of Data Table

Posted by watersoni PM | on Mon, 17/07/2006 - 09:00 5943 8 comments | report

I have several pivot tables linked to my data in the same spreadsheet. Everytime I enter new rows to the data, I go into each pivot table and using the wizard go and ensure that the last row is included in the pivot table.

Is there anyway that this can be updated automatically without re-entering the location of the data?
Ian Waterson

Comments

There are 8 comments. Login or register to view them.

.

David Carter | Fri, 03/02/2006 - 17:13

rivetting pivot stuff

Anonymous | Sun, 29/01/2006 - 21:22

solid gold tip

David Carter | Sat, 21/01/2006 - 18:41

Do you know VBA ?

AnonymousUser | Wed, 18/01/2006 - 16:13

couple of bits of advice for heavy pivot usage...

Anonymous | Fri, 20/01/2006 - 15:59

insert the new data above an existing row

David Carter | Tue, 17/01/2006 - 16:58

yes...

listerramjet | Tue, 17/01/2006 - 16:10

Excel 2007 new feature

jfranco | Tue, 12/10/2010 - 16:10