Everytime I or anyone else (shared spreadsheet) makes a change and then saves
the spreadsheet, it creates a "file" with no properties or extension. These
are starting to take up space on the server and cannot be deleted. How do I
stop these from being created or how do I delete them?

Sounds like temporary files. Once everyone closes the Excel file, do they go
away?

"shannonvds" wrote:

Everytime I or anyone else (shared spreadsheet) makes a change and then saves
the spreadsheet, it creates a "file" with no properties or extension. These
are starting to take up space on the server and cannot be deleted. How do I
stop these from being created or how do I delete them?

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

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.



shannonvds wrote:

Everytime I or anyone else (shared spreadsheet) makes a change and then saves
the spreadsheet, it creates a "file" with no properties or extension. These
are starting to take up space on the server and cannot be deleted. How do I
stop these from being created or how do I delete them?

--

Dave Peterson

The files do not go away nor can they be deleted. I have them dating back 6
months old.

"Nick B" wrote:

Sounds like temporary files. Once everyone closes the Excel file, do they go
away?

"shannonvds" wrote:

Everytime I or anyone else (shared spreadsheet) makes a change and then saves
the spreadsheet, it creates a "file" with no properties or extension. These
are starting to take up space on the server and cannot be deleted. How do I
stop these from being created or how do I delete them?

Is there a way to delete these files manually? I have tried many different
ways but it always comes up "cannot delete; access is denied".

"Dave Peterson" wrote:

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

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.



shannonvds wrote:

Everytime I or anyone else (shared spreadsheet) makes a change and then saves
the spreadsheet, it creates a "file" with no properties or extension. These
are starting to take up space on the server and cannot be deleted. How do I
stop these from being created or how do I delete them?

--

Dave Peterson

Close excel and retry.

If you can't delete them manually, maybe that's a hint that you don't have
permissions on that shared drive to delete files--and that explains why excel is
having trouble, too.

shannonvds wrote:

Is there a way to delete these files manually? I have tried many different
ways but it always comes up "cannot delete; access is denied".

"Dave Peterson" wrote:

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

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.



shannonvds wrote:

Everytime I or anyone else (shared spreadsheet) makes a change and then saves
the spreadsheet, it creates a "file" with no properties or extension. These
are starting to take up space on the server and cannot be deleted. How do I
stop these from being created or how do I delete them?

--

Dave Peterson


--

Dave Peterson