ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Duplicate files (https://www.excelbanter.com/excel-discussion-misc-queries/83917-duplicate-files.html)

Moni

Duplicate files
 
Hi

I have one excel file in the server to track the daily production of
all the statt and everyone in the network can access that excel. The
problem is whenever someone puts in somedate into that excel and save
that excel,an duplicate file is created in that folder where that excel
is placed with some junk name (ex.22D3A000 or 297DB000) and at the end
of the day I was shocked to see some 22 or 25 duplicate files created
everyday. This is occuping too much of the server space and everytime I
have to delete all those files. Can anyone suggest me why this is
occuring and how to stop it.

thanks
moni


Dave Peterson

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

Moni wrote:

Hi

I have one excel file in the server to track the daily production of
all the statt and everyone in the network can access that excel. The
problem is whenever someone puts in somedate into that excel and save
that excel,an duplicate file is created in that folder where that excel
is placed with some junk name (ex.22D3A000 or 297DB000) and at the end
of the day I was shocked to see some 22 or 25 duplicate files created
everyday. This is occuping too much of the server space and everytime I
have to delete all those files. Can anyone suggest me why this is
occuring and how to stop it.

thanks
moni


--

Dave Peterson


All times are GMT +1. The time now is 03:10 PM.

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