[mso] Re: How do I make this error go away?
- From: Pruscoe@xxxxxxx
- To: mso@xxxxxxxxxxxxx
- Date: Sat, 31 Aug 2013 15:03:45 -0400 (EDT)
Take it easy, James - we're trying to help. Maybe take a walk outside and a
few deep breaths. We DO know what you want to achieve. We are trying to
get to the bottom of the logic that Excel MIGHT be using.
We obviously don't KNOW what to tell you EXPLICITLY to accomplish what you
want and nothing else (i.e. kill the error message.)
Linda's suggestion is probably the best one yet (given that you have tried
- and now told us that you have tried - saving the spreadsheet with no
changes.) But, you indicated that it performs some calculations. That won't
get
saved in a text format, of course. Those could even be the key to the
message.
Please, ease up.
Peter
In a message dated 8/31/2013 2:38:12 P.M. Eastern Daylight Time,
MSO@xxxxxxxxx writes:
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
*************************************************************
Other related posts:
