Pivot Table Query

[Kim]

Hello

I use Pivot Tables a lot in my stats and although I can
normally work with them quite well, theres a reoccuring
issue that I can't seem to resolve. I have one
particular workbook that has lots of different worksheets
and one at the end, with a variety of pivot tables on
it. At the end of each month, I update the data on the
worksheets, then on each pivot table, I use the wizard
option to attempt to go back and re-select the relevant
updated data. Sometimes this is successful, but on other
(random) occasions, it won't let me and gives me the
message 'A PivotTable with that name already exists on
the destination sheet'. As this happens so randomly, I
can't seem to pinpoint exactly what causes it.

Can anyone help?

Thanks in advance,
Kim.

 

[Debra Dalgleish]

Instead of reselecting the data each month, you could use a dynamic
source range. There are instructions here:

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