Ok this spreadsheet I have is driving me crazy. It's a large workbook and has a lot of tabs and different pivot tables and charts. however whenever I need to make a change to the sheet to either add or subtract a machine that we are tracking, and I go to refresh the pivot table, I get an error that says Excel was unable to update the PivotTable named PivotTable2 because it would have overlapped another PivotTable.
I have tried putting PivotTable2 in it's own tab, i have tried deleting PivotTable2, I have tried moving the table, creating more space, and I have even tried deleting the tab that PivotTable2 was on and when I try and refresh another Pivot Table on the workbook it gives me the same error, even though I deleted PivotTable2. Any suggestions on how I can get rid of this error? I'm not sure what else to do.
I have tried putting PivotTable2 in it's own tab, i have tried deleting PivotTable2, I have tried moving the table, creating more space, and I have even tried deleting the tab that PivotTable2 was on and when I try and refresh another Pivot Table on the workbook it gives me the same error, even though I deleted PivotTable2. Any suggestions on how I can get rid of this error? I'm not sure what else to do.