Why won't my Pivot Tables recognise new data?

[martinbsp]

Hi

for some reason I cannot get my pivot tables to recognise that new dat
has been added to the worksheet. When I delete the old data and pu
new data in (I've tried adding 3000 records) the pivot tabl
disappeares and appears to be asking me to reconstruct it. I'
refering in this instance to the "Most Recent Activity Date
worksheet.

Please note I'm an Excel beginner - almost all of the construction o
this workbook has been down to a few kind souls out there (specia
mention to I.Savell).

Any help much appreciated.

I've attached the file for anyone who cares to have a stab.


Marti

Attachment filename: almost there.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=53567

 

[jeff]

Hi,

I put this line attached to a command button,
and the pivot table changed, but I'm not sure
about your data.

try it in a button or with a worksheet_change event?:

activeworkbook.refreshall

jeff

 

[pinmaster]

Hi
Your problem may have something to do with how you delete your ol
data. Try this, select your old data, then right click and click o
"clear contents".

Good luck!
Jean-Gu

 

[Dave Peterson]

And if the OP is adding back lots more data, it might be better using a dynamic
range for the pivottable source.

Debra Dalgleish has some nice instructions at:

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