excel 2003 crashes if change made prior in 2007

[Mike8675309]

I don't have much flexibility. A user via Sharepoint can open an excel in 2007, make some changes via code, save-close it. Another employee opens same file but in 2003. After running a little code message says "Excel is closing now" and does, no new work saved in 2003. Any ideas? Michael

 

[zelgar]

Is the person running 2007 using the Save-As to save as a 97-2003 version of Excel file? Also, there are some functions/macros that won't work the same in different versions of Excel.

 

[Mike8675309]

They save it as Excel 2007. Later another person opens it in 2003, and pushes a button. At couple seconds later is an ugly Excel crash "Excel is closing now...". So the first person makes a change and saves it in Excel 07. Later a second opens in Excel 2003 & after running some code "crash".

 

[zelgar]

The person using Excel 2007 will need to use the Save-As function to save it in the 97-2003 version of Excel so the person using the older version of Excel can work with the file. Try tis first. Additionally, if you have macros, they may need to be recoded since they might not work in the 2003 version of Excel.