Link to home
Start Free TrialLog in
Avatar of glenn_r
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
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of glenn_r
glenn_r

ASKER

What exactly did you change?
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...
Avatar of glenn_r

ASKER

That was also my findings. Something must have been corrupt. Thanks