E
Excel_Guru1979
Hi, I am working on a very large work book and I am having a difficult time
solving an error.
I copied a worksheet to a new tab (this way if anything happened I can still
have the original sheet). The old tab subtotaled fine and I was able to drill
down (by clicking the 1, 2, 3 or 4) on the top left of the sheet once
subtotaling was complete.
When I ran the subtotals on the new sheet, it will not allow me to drill
down (I can not click 1,2,3, or 4). I get the error "Can Not Shift Objects
Off Sheet"... First, I did not insert any object and there are no comments in
this file...
How can I get this to work?
solving an error.
I copied a worksheet to a new tab (this way if anything happened I can still
have the original sheet). The old tab subtotaled fine and I was able to drill
down (by clicking the 1, 2, 3 or 4) on the top left of the sheet once
subtotaling was complete.
When I ran the subtotals on the new sheet, it will not allow me to drill
down (I can not click 1,2,3, or 4). I get the error "Can Not Shift Objects
Off Sheet"... First, I did not insert any object and there are no comments in
this file...
How can I get this to work?