Pivot Table add new entries

  • Thread starter Thread starter Hannes
  • Start date Start date
H

Hannes

Hi
I am using excel's pivot feature to keep track of my account.
My question is:
I have already a list which looks like:
Date Cost Detail Amount
01.2003 Fixed Cost Gas 100 EUR
01.2003 Variable Cost Fun 200 EUR

and so on
Now I get my pivot table which shows all interesting data, just as I want.
But my problem is when I enter a new row e.g.
02.2003 Variable Cost Fun 300 EUR

(Note: new date)
Excel doesn't notice it to be part of the pivot table,
so I have to create the table again.
Is there a way to avoid this?

Thanks

Hannes
 
Is there a way to avoid this?

You could use a large range in the first place, eg: A1:D10000 ; tho' this
will cause problems if you want/need to group by time periods at a later
stage.

Alternatively you could define a dynamic named range for your data source,
then just Refresh after additions. See here for how -

http://www.contextures.com/xlNames01.html#Dynamic

Rgds,
Andy
 
Back
Top