cannot shift objects off sheet
This happens when inserting a column into a sheet created with 2003. When inserting a column into a sheet with 2003, it works with no error message. After opening the sheet in 2007, then inserting a column, the error "cannot shift objects off sheet" appear. I have deleted the columns from the edge of the data to the end of the sheet and rows from the bottom of the data to the end of the sheet. I have converted the sheet from .xls to .xlsx and .xlsm (to save the kill the merged cells macro). So far the only thing that works is to open the sheet in 2003 insert the column, save the sheet, then open again in 2007, or copy all the data to a new sheet in a new workbook in 2007. 2007 is not making us more productive.
|