Adding data to a 2007 pivot table


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
 
Ad

Advertisements

R

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

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

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Ad

Advertisements

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top