[mso] Re: How do I make this error go away?
- From: Pruscoe@xxxxxxx
- To: mso@xxxxxxxxxxxxx
- Date: Sat, 31 Aug 2013 14:14:10 -0400 (EDT)
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
*************************************************************
Other related posts:
