Error when saving workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat Wisch - 17 Apr 2007 00:20 GMT

Hi,

We have a user where I work who has Excel 2003 on her computer.
She is complaining that on certain excel documents which she has used
in the past that when she goes to save them after making changes, she
gets the error message:
"This file was created using a later version of Excel. There is a
remote possibility that certain workbook properties specific to the
later version may be lost if you save the file in this version. If
you want to preserve the original file, click Cancel, then rename the
new version using the save as command."

If she clicks the OK button and saves the file as is, when she opens
it up again and saves it she gets the same message.

If she does a save as and gives it a new name, then opens up the file
with the new name, when she saves that file she gets the same error
message.

The file appears to be saving correctly. Is there some way to get
that error message to go away? She claims that file was never opened
on a system that had a later version of Excel.......

Thanks,

Pat

Reply to this Message

Jim Rech - 17 Apr 2007 14:16 GMT

I've never heard of this error message and I've been going between versions
for years. If she starts Excel clean, with no auto-loading files (via
Start->Run "Excel.exe /s" (no quotes, there is a space before the slash))
does the problem occur?

Signature

Jim

| Hi,
|
[quoted text clipped - 22 lines]
|
| Pat

Reply to this Message

Pat Wisch - 17 Apr 2007 19:20 GMT

>I've never heard of this error message and I've been going between versions
>for years. If she starts Excel clean, with no auto-loading files (via
>Start->Run "Excel.exe /s" (no quotes, there is a space before the slash))
>does the problem occur?

Upon further examination, it does appear that the files she is seeing
the error while saving were indeed opened (and probably saved) on a
Mac that had Office 2004, because there are the hidden files
._filename.xls on the Windows file share, which are created when an
excel spreadsheet is opened and saved on a Mac. However, what is
weird, is not all of the files that have been opened on the Mac will
give the error when opened on a PC with Office 2003. I'm wondering if
there is some special formatting on the files that generate the
error???? In typical end user fashion, I don't think I'm getting the
whole story.....

I can create an excel file from scratch on a Mac with excel 2004, save
it to a windows file share, then open it with excel 2003 on a PC, make
changes, and save it with no errors.

I also found a way to make the error go away- Open the excel file
with Office 2007, save it as an excel xlsx format, then open it again
and save it in excel 2003 compatibility mode.

It's all pretty weird though.......

-Pat

Reply to this Message