Windows 7: problem saving excel spread sheet in 2010 to 97-2003 format

I have an new style Excel xlsx spreadsheet that I received from a customer through Email and I can open and re-save as an xlsx spreadsheet using excel 2010. I have saved it to my desktop. When I try to save it in the 97-2003 xls format. Excel then crashes right away and a window pops up. Microsoft Excel has stopped working. The first window reads that it is checking for a solution to the problem. Then it pops up with a second window within 2 seconds and it reads - A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.

The user that received this spread sheet is using 2003 and can not open it at all. It comes up with the window - trying to convert - and then says it can not convert the file.

I am using windows 7 64 bit with office 2010 Pro and all updates have been installed.

Thanks
Joel

Hi Muskiehunterjoe, welcome to Seven Forum.

You could try running the Compatability Checker or temporarily change the default save option:
Dealing with Excel 2010 File Formats - For Dummies

I opened it up with 2010 and ran the compatibility checker and it found nothing. I set the compatibility checker to run when saving and I tried to save it in the 97-2003 format again and excel crashed again right away. It came up with the same error message.


Thanks Irene for the reply.


Thanks
Joel

Joel, did you try changing the default 'Save' option, like this (as a temporary measure)? [I realise that this guide is for 2007, but should also apply to 2010]
Make Excel 2007 Always Save in Excel 2003 Format - How-To Geek
.
.

Tried the changing of default file format and when I click save it still saves it as the XLSX format. I do believe this is for new files only that it will automatically save as the old format. If it is already an XLSX format it will continue to save it as that. You still have to change it to XLS to save it in the old format. Anyway I tried it and it still crashes.


Thanks
Joel

Just found out that the user with 2003 has 2 people that send him Excel files both of them are XLSX files. He can open the files from one but not the other?

What can it be that one user is doing that messes up 2003 so it will not open the XLSX files?

Thanks
Joel

Since Excel 'stops working', I wonder if the file is corrupted in some way - repair/recover a damaged file:
How to recover data from damaged workbooks in Excel

Tried the repair on the file and it found nothing. I tried the original file that came in and it does the same thing. Excel crashes right when I click save when trying to save it in the old format.

I am going to try and get in contact with the person who sent it and see what they have and how they did what they did.

Thanks
Joel