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