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
Muskiehunterjoe

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
Irene

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
Muskiehunterjoe

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
Irene

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
Muskiehunterjoe

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
Muskiehunterjoe

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
Irene

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
Muskiehunterjoe

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
Thread Forum
Excel 2010 not saving.
Hi I have had office 2010 installed for about 2 months now but on a regular basis when I am working in Excel I am unable to save the document. When I select save or saveas nothing happens and when I close the document I am asked if I want to save and again if I select yes nothing happens. Currently...
Microsoft Office
Excel file saving problem in the network
I have a problem in saving an excel file on to another pc in the network, which has windows xp. But before I used in both pc’s windows xp & that time there were no problem saving on to the other pc. Now I use windows 7 32bit (Service pack1) in my pc & other pc on network is windows xp. Im doing...
Network & Sharing
Will Installation Of Outlook 2010 Install Ribbon In Access/Excel 2003
Hi, If I upgrade only the Outlook part of my Office 2003 installation to Outlook 2010 will the "Ribbon" style menu of Outlook 2010 be installed in my remaining Office 2003 menus? I accept that at some point I will probably have to get to grips with the "Ribbon" style menus introduced...
Microsoft Office
Office 2003 file saving problem
Not a fan of the Office 2007/2010/2013 ribbon so I continue using 2003. Beginning a few days ago about half the time when I save a file what happens is that a second file is created with the same name and "- Conflict 1.xxx" is appended to the file name. It is happening in both Word and Excel. ...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Printing Excel-sheet
Hi, I recently began learning Office 2010 and have an Excel specific question. The thing is, when I print an Excel-file I prepared the print is real tiny, almost unreadable as if the sheet should be divided into 6 or 7 pages rather than the 3 pages that I have somehow managed to get it down to. It...
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 05:27.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App