I'm sorry that I'm not making sense. EXCEL says These formats will be converted to the closest format available. It is NOT doing that. If it was doing that I would NOT continue to get the error every time I save it and then re-open it. I'm looking for a way to make it do that: i.e.: save it as an XLS --- do whatever is necessary to save it as an XLS --- so the error goes away and so that people who can only process an XLS can open it. OR explicitly tell me the problem so I can fix it. Right now it is LYING to me. It says it will convert on a save to the closest format available ... and it is not. Yes ... I continue to get the error with a save and reopen and a save and reopen and a save and reopen and a ... This "spreadsheet" is trivial. Mostly simple tables with no calculations. One table with some calculations. I'm just not understanding why what it is doing is different than what it says it will do. -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Pruscoe@xxxxxxx Sent: Saturday, August 31, 2013 1:14 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: How do I make this error go away? You didn't answer my question. Have you tried opening it and then saving it with NO changes. If you don't then get the message, you need to look at every property of every cell that you changed and consider whether it might be to blame. It could be anything - color, shading, font, anything. And it might not be easy to figure out unless you can have someone with, say, Excel 2003 open the XLS, and look at all the properties of that cell. Then compare the two results. (It might not even be a cell property - it could be one of the many for the workbook itself.) if you still get the message with no changes, then the earlier suggestion of disablin the compatibility check is probably your only option. In a message dated 8/31/2013 1:59:22 P.M. Eastern Daylight Time, MSO@xxxxxxxxx writes: EXCELLENT thoughts. Still not an answer. I work on many spreadsheets, all saved as XLS for compatibility and ONLY have the issue with this one. I am just not understanding the error message. It says These formats will be converted to the closest format available. It does not seem to be doing that. I want this spreadsheet to be like all my others, a no problem XLS spreadsheet and I cannot figure out how to get Excel to do that. I want it to toss aside anything/everything it wants and just give me an XLS spreadsheet. I'm still open to ideas. -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Pruscoe@xxxxxxx Sent: Saturday, August 31, 2013 12:52 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: How do I make this error go away? Presumably, when you open the file the next time, before saving it, you make some changes. Those changes might be the ones that Excel is bugging you about. Have you tried just opening the file then saving it with NO changes? If you still get the error message, then I presume that Excel is ASSUMING that a conversion from 2007 formal to XLS is going to involve back-conversion, and is issuing the error message regardless. Peter In a message dated 8/31/2013 1:38:11 P.M. Eastern Daylight Time, MSO@xxxxxxxxx writes: No I'm still not being clear. The error message says: Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available. I want Excel to convert them to the closest format available and save the file as XLS. Once that is done when I open/save the file the next time all should be ok because the formats will have already been converted and there will be no problem. What I do not understand is why, IF excel is converting to the closest format available, as it says it is ... why do I then get the error again. I want to create an error free XLS file. Do whatever is necessary to create an error free XLS file. -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Patty Ball Sent: Saturday, August 31, 2013 9:27 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: How do I make this error go away? You can try disabling the compatibility checker if all you want to do is get rid of the message: To disable the Compatibility Checker 1. ( Excel 2007 ) On the Office button, click Prepare , click Run Compatibility Checker , and then clear the Check compatibility when you save this workbook box. Patty Ball Marblehead, MA ----- Original Message ----- From: MSO@xxxxxxxxx To: mso@xxxxxxxxxxxxx Sent: Saturday, August 31, 2013 10:11:16 AM Subject: [mso] Re: How do I make this error go away? 2007 -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Patty Ball Sent: Saturday, August 31, 2013 9:09 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: How do I make this error go away? What version of excel are you using? Patty Ball Marblehead, MA ----- Original Message ----- From: MSO@xxxxxxxxx To: mso@xxxxxxxxxxxxx Sent: Saturday, August 31, 2013 9:52:57 AM Subject: [mso] Re: How do I make this error go away? Sorry. I was not clear. How do I make the error go away SAVING IT TO AN XLS file (that is a requirement). The "error message" says that the no longer supported features will be converted. So if they are converted, I do not understand why I get the error when I reopen the saved XLS file and then save it again. -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Patty Ball Sent: Saturday, August 31, 2013 8:46 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: How do I make this error go away? The newer excel programs use an xlsx extension not xls anymore. If you try to save it to an earlier format, xls, you will see the error which is telling you that some of the features cannot be used or will not show in an earlier format. Simply save it with the xlsx extension and you should be fine Patty Ball Marblehead, MA ----- Original Message ----- From: MSO@xxxxxxxxx To: mso@xxxxxxxxxxxxx Sent: Saturday, August 31, 2013 9:39:44 AM Subject: [mso] How do I make this error go away? When I save my Excel spreadsheet to an XLS file I get this error: Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available. So I click continue and go on. The next time I open the file and save the file I get the same error. How do I make the error go away? ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxx. To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to share files with the group, you must join our Yahoo sister group. This group will not allow for posting of emails, but will allow you to join and share problem files, templates, etc.: http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE SHARING ONLY. If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxx. To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to share files with the group, you must join our Yahoo sister group. This group will not allow for posting of emails, but will allow you to join and share problem files, templates, etc.: http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE SHARING ONLY. If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************