I copied my workbook to another folder. I updated my Sales Data with another month of sales. When trying to Refresh All to update my pivot tables I get these messages:
There's already data in [WORKBOOK NAME]SHEETNAME. Do you want to replace it? If I say Yes, nothing happens.
A PivotTable report cannot overlap another PivotTable report. I have put columns and rows between my Pivot Tables and cannot find any overlap.
How do I fix these problems so that I can finalise my tables and reports?
Hi Kathie,
You're best to remove the other PivotTables to their own sheets because there will be something that has changed that's resulting in the PivotTables wanting to expand further than you think. I always recommend one PivotTable per sheet for this reason.
Mynda
