2007 Conversion

[dave8]

I just converted my 2003 workbook application to 2007 (I think). The file is now in .xlsm format. However, when I launch this (.xlsm) workbook in 2003, it goes thru a file conversion process and comes back with following error:

"The file was created in a newer version of Microsoft Excel. The file has been
converted to a format you can work with, but the following issues were
encountered. The file has been opened in read-only mode to protect the
original file.

- Unitialized ActiveX controls will not be opened in this version of Excel. "


How do I correct this so I can run the program interchangebly between 2003 and 2007?

 

[Joe4]

As a general rule of thumb, if you save files down to the earliest version, they should run on all later versions. So, save the file as and .xls file, and it should run in both 2003 and 2007.

Another option is to download the compatibility executable from Microsoft, to read 2007 files in 2003:
http://www.microsoft.com/downloads/...70-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en

 

[dave8]

So, is it suggested then, that if users are running an application written in 2003 but is running 2007 to save it as an earlier version?

 

[Joe4]

If you are running 2007, there is no harm in running workbooks created in 2003.

If anyone who uses this workbook has 2003, I would recommend leaving it as a 2003 file. If all users have 2007, you can convert it to a 2007 file if you like (but don't need to).