I get the message while deleting the pivot table. I just want to get rid of the pivot table.
Here are the options I tried but the error message doesnt seem to go away :
Opt1 -Restarted the machine
Opt2 -Tried to change the data source
Opt3 -Tried to copy paste pivotetable to some other location.
Opt4 -Deleted the data source, and tried to refresh the pivot table.
have you just tried selecting the whole table then delete ?
seems strange
can you attack the workbook with it in here?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Here is the one, where the second(below) pivottable doesnt just go away.
i just selected h21: i27 hit delete away it went
I know I have dont that multiple times before, now that i dont see that happening.
Thats why i restarted the MS office and my box as well. It happening in another sheet as well.
I deleted all the old sheets and took data from even more older sheet.
Now if I select and delete it goes away
Strange isnt it ?
Thank you Thank you for responding the thread Martindwilson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks