I've searched this forum regarding this error message (and Google) but I still cannot find a way to resolve the "Cannot shift objects off sheet" error when trying to HIDE columns. I'll try to provide as much info as possible:
ANY suggestions with this issue would be helpful. This is a critical spreadsheet for us and being able to hide columns and retain the comments is essential.
Thanks.
- The workbook is saved in Excel 2003 format, though a mix of 2003 & 2007 users use this file
- The workbook has comments in just about every column. These comments are a required part of the worksheet
- Up until last week, hiding columns was not a problem. Nothing has changed in the file (that we can see).
- The columns contain data up to EZ and a new column is added everyday
- We frequently unhide all columns to review data and then hide all of the columns up to a couple of days ago. We can no longer do that.
- If we try to hide about one screen's worth of columns at a time instead of the whole range, it usually (but not always) works. This is very time consuming and impractical.
- We have tried any suggestions in the MS KB related to this error but to no avail (show ALL objects is already turned on).
- We've tried deleting all rows and columns outside the used data range but this doesn't work either.
- Someone suggested to set all the comments to "move and size with cells" but we cannot find this option in Excel 2007.
ANY suggestions with this issue would be helpful. This is a critical spreadsheet for us and being able to hide columns and retain the comments is essential.
Thanks.