Excel 2007 - Compatibility Checker

[Barb Reinhardt]

I'm finding that I'm getting a compatibility error within one workbook when I
run the compatibility checker. I have found that it depends on which
worksheet of the workbook is active when I run it. When I select some
sheets and run it, I get no error, and when I select others, I get an error
(and it's always the same one).

I'm getting the following error:

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.

I can't find anything that might cause this problem. In the affected cells,
there is data validation and I've even removed it to see if it's the cause,
but have had no success. I'm also not finding any named ranges in this cell.
What's especially strange is that if I run the compatibility checker on the
worksheet with the supposed problem, it doesn't find anything.

Can someone assist?

Thanks,
Barb Reinhardt

 

[Barb Reinhardt]

The cell that had the compatibility error referenced a cell that was merged
with another one. When I removed the merge of the reference cell, there was
no more compatibility error.

 

[Barb Reinhardt]

If I merge the cells with the error and unmerge all of the other reference
cells, I'm still getting the error. The way this is set up, it really needs
to be merged (as much as I hate doing that). Does anyone have any ideas?

 

[Barb Reinhardt]

I have a very small workbook that has the same problem (entries in two
cells), if someone wants me to send it to them.

 

[David.K.Dickson]

Getting same problem

Barb,

I get exactly the same problem.

We run Office 2007, but our clients run Office 2003. We have a spreadsheet that I maintain and we share with them. Therefore although I am running Excel 2007, I have it in "Compatability mode" and cannot create columns beyond IV or rows beyond 65536.

When I click "Save" on some of the tabs, it just does it. On other tabs, clicking "Save" causes the Compatability Checker to put up the message

"This workbook contains data in cells outside of the row and column limits 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. Location: 'Deliverables'"

and

"This workbook contains data in cells outside of the row and column limits 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. Location: 'Groups'"

'Deliverables' and 'Groups' are the two main sheets in this workbook.

It tells me that there are 18 occurrences in 'Deliverables' and 3 in 'Groups'. Clicking on the first "Find" hyperlink takes me into the 'Deliverables' sheet and highlights cells AB3:AW157 - hardly outside the specified limits. And none of these cells are (or ever have been) merged.

If you find the answer, please let us know.
If I find the answer, I will post it here.

David.