We have a workbook with a link to another workbook. All of a sudden when we
open the workbook to make a change and save it, it creates these additional
files with no known file extension. They are named with numbers and letters
such as F7D8100, no file extension. Does anyone know what could cause this?
--
LFP

The file you are suggesting is prob a tracking file- similar to a mini backup
for 1 file. Often used for shared workbooks so you can retrieve old copies if
something gets deleted by another user.
Check your workbook and see if it shared or tracking changes.

Tools -Share w-book.
If this is so go to tools- Share workbook, and on the advanced tab uncheck
time to keep changes.


Dave


"LFP" wrote:

We have a workbook with a link to another workbook. All of a sudden when we
open the workbook to make a change and save it, it creates these additional
files with no known file extension. They are named with numbers and letters
such as F7D8100, no file extension. Does anyone know what could cause this?
--
LFP

I don't think you'll find that this is true.

There is an option under File|SaveAs|tools|General options (in xl2003) that
allow you always create a backup.

But this doesn't have the same kind of name as what the OP wrote.

dave m wrote:

The file you are suggesting is prob a tracking file- similar to a mini backup
for 1 file. Often used for shared workbooks so you can retrieve old copies if
something gets deleted by another user.
Check your workbook and see if it shared or tracking changes.

Tools -Share w-book.
If this is so go to tools- Share workbook, and on the advanced tab uncheck
time to keep changes.

Dave

"LFP" wrote:

We have a workbook with a link to another workbook. All of a sudden when we
open the workbook to make a change and save it, it creates these additional
files with no known file extension. They are named with numbers and letters
such as F7D8100, no file extension. Does anyone know what could cause this?
--
LFP

--

Dave Peterson

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.

If you're seeing that funny named file, then something is going wrong.

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.


LFP wrote:

We have a workbook with a link to another workbook. All of a sudden when we
open the workbook to make a change and save it, it creates these additional
files with no known file extension. They are named with numbers and letters
such as F7D8100, no file extension. Does anyone know what could cause this?
--
LFP

--

Dave Peterson