'Cannot shift objects off sheet' error message (group/outline)

[Peter]

When I try to hide or group columns in an Excel file, I get the warning
message: 'Cannot shift objects off sheet'. Why does this happen? How do I
remove this blocking factor? Thank you,

Peter

 

[FSt1]

hi
i'ver never gotten that message when trying to hide columns only with trying
to add but i do get that message when excel has lost it's used range
reference and thinks i'm am using a lot more space on the sheet than I really
am.
see this site on how to reset the used range. might clear the problem.

http://www.contextures.com/xlfaqApp.html#Unused

regards
FSt1

 

[Eddy]

When I try to hide or group columns in an Excel file, I get the warning
message: 'Cannot shift objects off sheet'. Why does this happen? How do I
remove this blocking factor? Thank you,

Peter

Hi Peter

I am experiencing the same problem, did you find the solution.

Edward