ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Spurious files created on Save (https://www.excelbanter.com/excel-discussion-misc-queries/207329-spurious-files-created-save.html)

Chris Skrimshire

Spurious files created on Save
 
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



Bob I

Spurious files created on Save
 
perhaps the anti-virus software you use is interfering? Is it set to
scan Office files? look for some "Office Add-in" within the A-V
preferences.

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é?




Dave Peterson

Spurious files created on Save
 
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

Bernard Liengme

Spurious files created on Save
 
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

Spurious files created on Save
 
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

Bernard Liengme

Spurious files created on Save
 
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

Spurious files created on Save
 
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


All times are GMT +1. The time now is 05:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com