Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compatability Checker Question
I have a workbook designed in Excel 2003. When it is opened in Excel
2007 oe 2010, it functions fine. However, when the user goes to save it (even if they have not changed it at all) the compatability checker pops up and says there is data outside of the acceptable range on one sheet. But it is not true. When I unprotect the sheet, the FIND function goes to some totally blank cell in the middle of the workbook. Then when I try to save it again, it tells me that there are data validation issues where on one sheet, another sheet is referenced. But there are no such references in my workbook. And again, the FIND function in the checker simply does not find them, and the message then disappears. But others pop up. All bogus. If I go ahead and save as a 2003 file anyway, it appears that the file functions fine with no loss of functionality as far as I have been able to discover. Is there anything I can do so that users other than me are not intimidated by this Compatability Checker message that appears to be in error? Or is there something wrong with my workbook? Is the Compatability Checker faulty? I am at a loss as to how to deal with this. I know I can switch the Compatability Checker off when I personally use the workbook by unchecking the option, but the 'soccer moms' that use the program are intimidated by the message. If I try to block the message using VBA, the workbook crashes when opened on Excel 2000 or 2003. Can anyone shed some light on what might be going on? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Compatability Checker | Excel Discussion (Misc queries) | |||
Disabling Compatability Checker in Automation | Excel Programming | |||
Excel 07 compatability checker | Excel Discussion (Misc queries) | |||
Excel 2007 Compatability Checker | Excel Discussion (Misc queries) | |||
Compatability checker | Excel Discussion (Misc queries) |