Help! I have a workbook full of pivot tables from which I create reports (with 2 worksheets of corresponding data). For some unknown reason, this month when I updated the data and went to refresh the pivot tables, I get the following message: "Pivot Table cannot overlap Another Pivot Table"
There is no reason for me to get this message - I did not change the layout on the worksheet and there is not more than one pivot table on the sheet. Further, I get this on many of my sheets, not just one. I also tried going back to an earlier version of my file, updating it, and the same thing happened.
Can anyone help me with this? I really do not want to have to recreate my workbook/pivot tables, and I do not want to run across this in the future without a solution.
Thanks much.
There is no reason for me to get this message - I did not change the layout on the worksheet and there is not more than one pivot table on the sheet. Further, I get this on many of my sheets, not just one. I also tried going back to an earlier version of my file, updating it, and the same thing happened.
Can anyone help me with this? I really do not want to have to recreate my workbook/pivot tables, and I do not want to run across this in the future without a solution.
Thanks much.