Excel 2003 to Excel 2010 and back to Excel 2003 problem

[keops9876]

Hi guys!

For the last cupple of hours i've been trying to solve a problem with Excel!
I have following configuration:

Excel 2003+ SP3
Excel 2010
Microsoft Compatibility package
------------------------------------------------

I have Excel 2003 files. I've opened them in Excel 2010, did nothing, just saved them in Excel 2010 format(XLSM). When I try to open them in Excel 2003, I get the following message:
The file was created in a newer version of Excel........
- One or more cells in this workbook contain data validation rules which refer...........


I tried many things:
- using named ranges in excel 2010
- using VBA: If Val(Application.Version) = 11 Then
ActiveWorkbook.CheckCompatibility = False
End If

No matter what I do, the message in Excel 2003 keeps poping up. I know there is a problem with compatibility checker. But all solutions are for saving excel file to 97-2003 in Excel 2010, where you can disable compatibility checker. But I couldn't find any solution for my problem.


Tnx

[Mallycat]

What is the actual problem? If you save a file in 2010, there will be issues in 2003. Microsoft didn't know much about the 2010 version when it developed the 2003 version. If you want to open in both versions, you should save the file in 2010 using the backwards compatible file formats.