B
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
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