A
agd21
Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I'm working with a large spreadsheet (2.7 MB). Recently I notice that when I select an entire column(s) by clicking the column heading and try to narrow the column I get a Dialog box saying: "Cannot shift objects off sheet". I click OK but the column doesn't narrow.
I've tried deleting rows and columns below and beyond the far right the active cells of the spreadsheet, but the Dialog box still appears when narrowing columns. In fact, when I tried to delete some columns to the far right I got this Dialog box again.
I've tried a Go To > Special > Objects, but get "No Objects Found." Nor are there any images in the spreadsheet that I know of. I don't have any hidden rows or columns. A few cells have comments.
I can open a new spreadsheet with no data in it and narrow columns with no problem.
This spreadsheet has 212 columns X 300 rows; many cells have equations and conditional formatting. There are no cell references leading off spreadsheet.
I've never seen this Dialog before and don’t know what it means.
Any suggestions?
Using Excel 2004 v. 11.5, Mac OS 10.4.11
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I'm working with a large spreadsheet (2.7 MB). Recently I notice that when I select an entire column(s) by clicking the column heading and try to narrow the column I get a Dialog box saying: "Cannot shift objects off sheet". I click OK but the column doesn't narrow.
I've tried deleting rows and columns below and beyond the far right the active cells of the spreadsheet, but the Dialog box still appears when narrowing columns. In fact, when I tried to delete some columns to the far right I got this Dialog box again.
I've tried a Go To > Special > Objects, but get "No Objects Found." Nor are there any images in the spreadsheet that I know of. I don't have any hidden rows or columns. A few cells have comments.
I can open a new spreadsheet with no data in it and narrow columns with no problem.
This spreadsheet has 212 columns X 300 rows; many cells have equations and conditional formatting. There are no cell references leading off spreadsheet.
I've never seen this Dialog before and don’t know what it means.
Any suggestions?
Using Excel 2004 v. 11.5, Mac OS 10.4.11