Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Compatibility Checker
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Compatibility Checker
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" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Compatibility Checker
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" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Compatibility Checker
I have a very small workbook that has the same problem (entries in two
cells), if someone wants me to send it to them. "Barb Reinhardt" wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off compatibility Checker in Excel 2007? | Excel Discussion (Misc queries) | |||
Compatibility Checker | Excel Discussion (Misc queries) | |||
disable the Compatibility Checker in Excel | Excel Discussion (Misc queries) | |||
Can I turn off Compatibility Checker? | Excel Discussion (Misc queries) | |||
Compatibility Checker Problem | Excel Discussion (Misc queries) |