When attempting to insert a new row in an Excel document you recieve an error message saying ‘Cannot shift objects off sheet’ and Excel fails to add the new row.
- With the Excel document open
- Select the ‘Office’ menu followed by ‘Excel Options’
- Select the ‘Advanced’ menu
- Scroll down to ‘Display options for this workbook’
- Under ‘For objects, show’ select ‘All’
- Click ‘OK’ to save the changes