MS Excel File - Saving Problems - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

MS Excel File - Saving Problems

£0.00 @
Hello, I've got a spreadsheet which I've sent to my sister who uses MS Office 2003 and I use MS Office 2007, she can use the spreadsheet but has problems saving the spreadsheet, the following message … Read More
ninj4z Avatar
8y, 4m agoPosted 8 years, 4 months ago
Hello, I've got a spreadsheet which I've sent to my sister who uses MS Office 2003 and I use MS Office 2007, she can use the spreadsheet but has problems saving the spreadsheet, the following message comes up when trying to save:

This file was created using a later version of microsoft excel. If you save this file using microsoft excel 97, information created with features in the later version may be lost. To retain the information in the original file click No and use the Save As command (File menu) to save this file with a different name. To continue with the Save click Yes. Continue with save? Yes or No

Anyone had this problem before or know how to resolve it so that the file can be saved by a click of a button rather than viewing the above message each time when trying to save?

Any thoughts or links appreciated.

Thanks.
ninj4z Avatar
8y, 4m agoPosted 8 years, 4 months ago
Options

All Comments

(9) Jump to unreadPost a comment
Comments/page:
#1
You can just save the file as excel 2003
#2
Rather than just saving using the save button or the save icon. Select Save As. When the Save As dialog box appears use the drop down at Save As Type and Select Microsoft Excel 97-2002 - or use whatever one you need.

This will solve all the problems.

Regards
#3
scotsann
Rather than just saving using the save button or the save icon. Select Save As. When the Save As dialog box appears use the drop down at Save As Type and Select Microsoft Excel 97-2002 - or use whatever one you need.

This will solve all the problems.

Regards


That's what I have to do with Word 2007 :thumbsup:
#4
scotsann
Rather than just saving using the save button or the save icon. Select Save As. When the Save As dialog box appears use the drop down at Save As Type and Select Microsoft Excel 97-2002 - or use whatever one you need.

This will solve all the problems.

Regards


Had the same problem with a Word Document and changed it to 97-2003, worked fine went I sent that, done the same with the Excel file, before it wouldn't save at all, after changing it, the error message in my first post keeps popping up :?
#5
ninj4z;4173584
Had the same problem with a Word Document and changed it to 97-2003, worked fine went I sent that, done the same with the Excel file, before it wouldn't save at all, after changing it, the error message in my first post keeps popping up :?


Its not so much an error message as a warning - a similar thing will happen with most powerpoint files. Use 'save as' and Excel 97-2003 as said, double check everything looks okay but it should be fine!
#6
ninj4z
Had the same problem with a Word Document and changed it to 97-2003, worked fine went I sent that, done the same with the Excel file, before it wouldn't save at all, after changing it, the error message in my first post keeps popping up :?


I think it's just a warning message should be fine.
banned#7
#8
Office 2007 saves files with an x at the end, ie Letter.docx or Spreadsheet.xlsx etc and older versions of these programmes can struggle to open them. As already said use 'Save As' and save as Excel 97-2003 Workbook
#9
You can set your Excel to always default save as 97-2003 file that way you'll get most compatibility when sending your files to others. Just go to "Excel Options" in the office button.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!