Pivot Table conundrum

[John Miller]

I am logging telephone calls per month and have been playing around with the
pivot table function, I'm having a problem in that I want to specify the
number of rows to the endth row, ie. 65536 to throw up the cost per call in
the table so that in future when I add call data to the master sheet the
pivot table will update autmatically, when I do this the result in the table
records the number of events as opposed to the costs, I should point out
that I am using the layout facility within the wizard correctly as
instructed, it seems to work fine when the range is to the end of the last
row of data, does anyone know why this is ?

looking forward to a response.

John

 

[Debra Dalgleish]

You can use a dynamic range as the source:

http://www.contextures.com/xlPivot01.html

Then when you add new data, it will be automatically detected when you
refresh the pivot table.

 

[John Miller]

Thank you Debra.

You can use a dynamic range as the source:

http://www.contextures.com/xlPivot01.html

Then when you add new data, it will be automatically detected when you
refresh the pivot table.