glenn_r
asked on
Excel not allowing me to insert a new row
Excel 2010
Click home ribbon insert button displays the message 'Cannot shift objects off sheet'
The options 'display options for this wookbook' 'for objects show: (All)' is selected
The xls has a bit of legacy code in it. In my version of the file i removed all the code but it did not seems to solve the problem. I simply want to inert entire new rows at row 3720.
Note if I remove a few rows from the sheet i can then add a few new rows. Seems to be some type of a limit set.
Fixbook-NEW-orig.xls
Click home ribbon insert button displays the message 'Cannot shift objects off sheet'
The options 'display options for this wookbook' 'for objects show: (All)' is selected
The xls has a bit of legacy code in it. In my version of the file i removed all the code but it did not seems to solve the problem. I simply want to inert entire new rows at row 3720.
Note if I remove a few rows from the sheet i can then add a few new rows. Seems to be some type of a limit set.
Fixbook-NEW-orig.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I found out the problem is with you button which was the object..i deleted it and recreated it and rest everything got fixed...Again now their was no specific reason why the button was behaving this manner...
ASKER
That was also my findings. Something must have been corrupt. Thanks
ASKER