2007 is not making us more productive.

Tell me about it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


<Phil James wrote in message ...
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.