I'm getting a warning message when I try to save a particular .xls file in Excel 2007. It's clear to me that the message is
erroneous, but our customers will find it very confusing. If anyone can shed light on what causes the message or how to work
around it, I'd be very grateful.
I open this particular Excel 97-2003 workbook in Excel 2007, and it shows that
it's running in compatibility mode. So far so good. But then when I try to save it with another name but still file type
Excel 97-2003 workbook (*.xls), the compatibility checker comes up and complains as follows:
--- start of
compatibility checker message ---
The following features in this workbook are not supported by earlier versions of
Excel. These features may be lost or degraded when you save this workbook in an earlier file format.
loss of functionality
This workbook contains data in cells outside of the row and column limit of the selected
file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will
return a #REF! error.
--- end of compatiblity checker message ---
Just after the message are hyperlinks
for "Find" and "Help". If I click "Find", it goes to cell F42, which is well within the limit of 256 columns and 65,536
rows. If I click "Help", it goes to some generic help which is not useful.
The error message doesn't make sense
anyway, because I'm in compatibility mode, having loaded an Excel 97-2003 workbook, so the original file couldn't possibly
have any data outside the limits, and I haven't changed anything. Even if I did, compatibility mode shouldn't let me go
outside the limits.
I get the same message if I just do Prepare->Run Compatibility Checker. The problem happens
quite consistently with this workbook.
I've opened a support request with Microsoft about this, but if anyone has
seen this before and has a suggestion, I'd love to hear it. Thanks.