Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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


02 Dec 2011   #1

7 -64 bit
 
 
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

My System SpecsSystem Spec
.

03 Dec 2011   #2

Windows 7 Home Premium 64bit
 
 

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

Quote:
Running the Compatibility Checker

You also can run the Compatibility Checker in Excel 2010 to find any potential compatibility issues if you plan to save the file in the Excel 97-2003 file format. To use this feature, follow these steps:
  1. In Excel 2010, open the workbook you want to check.
  2. Click the File tab, click the Check for Issues button on the Info tab (on the left), and click Check Compatibility.
    The Microsoft Excel – Compatibility Checker dialog box appears. Any features that might cause issues are listed in the Summary box.
  3. Click OK to close the dialog box.
If you’re working in an office where all the workbooks you produce with Excel 2010 must be saved in the old Excel 97-2003 file format for compatibility, you can change the program’s default Save setting so that the program always saves all new workbooks in the older file format. To do this, open the Save tab of the Excel Options dialog box (File→Options→Save) and then select Excel 97-2003 Workbook in the Save Files in This Format drop-down list box.
My System SpecsSystem Spec
06 Dec 2011   #3

7 -64 bit
 
 

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
My System SpecsSystem Spec
.


06 Dec 2011   #4

Windows 7 Home Premium 64bit
 
 

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
.
.

Quote:
Start by clicking that big round Office Button in the upper left hand corner.

.
.

In the resulting menu, click the Excel Options button.


Now click the Save tab, and then change the “Safe files in this format” dropdown to “Excel 97-2003 Workbook”.

My System SpecsSystem Spec
06 Dec 2011   #5

7 -64 bit
 
 

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
My System SpecsSystem Spec
06 Dec 2011   #6

7 -64 bit
 
 

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
My System SpecsSystem Spec
07 Dec 2011   #7

Windows 7 Home Premium 64bit
 
 

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
My System SpecsSystem Spec
07 Dec 2011   #8

7 -64 bit
 
 

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
My System SpecsSystem Spec
Reply

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




Thread Tools



Similar help and support threads for2: problem saving excel spread sheet in 2010 to 97-2003 format
Thread Forum
Excel file saving problem in the network Network & Sharing
Solved Will Installation Of Outlook 2010 Install Ribbon In Access/Excel 2003 Microsoft Office
Office 2003 file saving problem Microsoft Office
Solved Excel 2003 sum formula problem Microsoft Office
Excel 2010 not saving. Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Printing Excel-sheet Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 06:19 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33