Spreadsheet Clone

  • Thread starter Thread starter George
  • Start date Start date
G

George

I created a spreadsheet we share at work over a LAN system. The spreadsheet
is password protected to modify. It seems like anytime someone opens it and
then closes it there is an extra file in the same folder that's on the LAN
with some strange number for a title, sometimes there maybe a dozen of these
files by the end of the day. I delete these files each day and it's doesn't
seem to hurt anything - what is creating them.
 
George said:
I created a spreadsheet we share at work over a LAN system. The
spreadsheet is password protected to modify. It seems like anytime
someone opens it and then closes it there is an extra file in the same
folder that's on the LAN with some strange number for a title,
sometimes there maybe a dozen of these files by the end of the day. I
delete these files each day and it's doesn't seem to hurt anything -
what is creating them.
Click to expand...

Excel is creating them. They're temporary files. It's just how Excel
works. It's likely your users' permissions in this shared directory
are to blame for Excel (running on user machines under user logins)
not being able to delete these temporary files.
 
Just to add to Harlan's response...

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.
 
Back
Top