Adding data to a 2007 pivot table

  • Thread starter Thread starter Dianeg
  • Start date Start date
D

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
 
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

Dianeg said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
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
 
Back
Top