Someone suggested to set all the comments to "move and size with cells" but we cannot find this option in Excel 2007.ĪNY suggestions with this issue would be helpful.We've tried deleting all rows and columns outside the used data range but this doesn't work either.We have tried any suggestions in the MS KB related to this error but to no avail (show ALL objects is already turned on).This is very time consuming and impractical. 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.We frequently unhide all columns to review data and then hide all of the columns up to a couple of days ago.The columns contain data up to EZ and a new column is added everyday.Nothing has changed in the file (that we can see). Unhide columns Select the adjacent columns for the hidden columns. Note: The double line between two columns is an indicator that youve hidden a column. If Left(HTMLDiv.className, 46) 'financialReport financialContent balanceSheet-' And w < p Then 'two divs have these classess on the first run.
Right-click the selected columns, and then select Hide. Up until last week, hiding columns was not a problem. Select one or more columns, and then press Ctrl to select additional columns that arent adjacent.These comments are a required part of the worksheet The workbook has comments in just about every column.The workbook is saved in Excel 2003 format, though a mix of 2003 & 2007 users use this file.I'll try to provide as much info as possible: 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.
0 kommentar(er)
