Spreadsheet Clone

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George - 17 Dec 2007 17:13 GMT

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.

Reply to this Message

Harlan Grove - 17 Dec 2007 21:58 GMT

George <Geo...@discussions.microsoft.com> wrote...

>I created a spreadsheet we share at work over a LAN system. The
>spreadsheet is password protected to modify. It seems like anytime
[quoted text clipped - 3 lines]
>delete these files each day and it's doesn't seem to hurt anything -
>what is creating them.

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.

Reply to this Message

Dave Peterson - 17 Dec 2007 22:55 GMT

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.

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

Signature

Dave Peterson

Reply to this Message

Rate this thread: