ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Deleted the pivot table - continue to get the "overlap" error message (https://www.excelbanter.com/excel-discussion-misc-queries/111792-deleted-pivot-table-continue-get-overlap-error-message.html)

[email protected]

Deleted the pivot table - continue to get the "overlap" error message
 
When working with a spreadsheet, I had created a pivot table below my
data in columns Q and R. I then decided the grouped data was
irrelevant, selected the cells the report was located in, and hit
delete (shifting cells up).

Now, I have another pivot table I'd like to create and want to put it
below the data in columns Q and R for presentation reasons (so the
sheet doesn't seems disorganized). However, when I try to put it into
colums Q or R, I receive the error message that a "pivot table report
cannot overlap another pivot table report".

There's nothing in these cells that I can see - any thoughts on how to
really delete the previous pivot table report...especially now that
it's invisible?

Thanks!



All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com