Adding data to a 2007 pivot table

[Dianeg]

Hi

sorry if this is a stupid question, how do I add refresh a pivot table to
include data added to the END of my existing data? Do you have to recreate
the pivot table with the extended range? I know that you can just refresh it
if new data is include inside the existing range

Thanks in advance
Diane

 

[Roger Govier]

Hi Diane

If you go to your Source data, and choose Insert tab>Table>my table has
Headers you will see a new Design tab and in the first section>Properties
you will see a table name (Table1) which you can call anything you want e,g,
myData

Right click on your PT>Options tab>Data>Change Data Source>in the dialogue
that appears for Table/Range>=myData>OK

A table will automatically grow (or shrink) as data is added (removed), so
your PT will always look at the whole of the data you have.
As a generality always choose Insert tab>Table and then choose Summarize
with Pivot Table from the Design tab so you don't have to do this again.
--
Regards
Roger Govier

Hi

sorry if this is a stupid question, how do I add refresh a pivot table to
include data added to the END of my existing data? Do you have to
recreate
the pivot table with the extended range? I know that you can just refresh
it
if new data is include inside the existing range

Thanks in advance
Diane

__________ Information from ESET Smart Security, version of virus
signature database 4767 (20100113) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4767 (20100113) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Ashish Mathur]

Hi,

Just convert the range (select the header row when selecting the range) to a
Table (Ctrl+L or Ctrl+T). A table auto expands the data range. Now when
you add data by rows, just right click on the pivot table and refresh (the
usual way)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com