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?

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.

Excel_Guru1979 wrote:

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?

--

Dave Peterson