xl2003 and before didn't work the same way as word (same version).



Bernard Liengme wrote:

From http://support.microsoft.com/default.aspx/kb/211632 and
http://support.microsoft.com/kb/89247/ (this is for Word 97)
it appears the temporary file name with ~ as the lead character is how MS
saves all Office files
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dave Peterson" wrote in message
...
You're using xl2007.

I think that the way excel saves (and marks a file in use) has changed.
The
stuff I wrote will apply to xl2003 and below.

Thanks for amplification.



Bernard Liengme wrote:

With BOOK2.XLSX saved and still open, in the folder I see ~Book2.XLSX
with a
greyed out icon
As soon as I close BOOK2 that listing in the folder goes away
So it is not the normal Save that is giving the OP file names beginning
8AAF...
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dave Peterson" wrote in message
...
Are you sure that your changes are really being saved?

When excel saves the file, it saves it as a temporary file with a funny
name (8
characters--no extension) in the same folder.

If the save is successful, xl will delete the original (or rename it to
its
backup name (like "backup of book1.xlk)) and if that's successful, xl
will
rename the funny named file to the original's name.

Common things that get blamed for interruptions to this process are
antivirus
software poking its head in or network errors--either permissions or
physical
problems.

===
I've never seen excel create the funny named file, but not populate the
file.

Chris Skrimshire wrote:

Possibly as a result of something inadvertantly tinkered with, I find
that
each time I save versions of a particular spreadsheet, saved to the
same
or
different names, there is also created each time another file.

These other files are suffix-less, are of 0 kbytes size and have
hexadecimal
number names of the form '8AAF8000' - a different, and rising, number
each
Save time. Their presence, or deleting them, seems to have no
consequence.

Qué?

--
Regards,

Chris

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson