Hi I have a weird problem.
We have a shared drive with excel documents only in different folders.
and the files a duplicating with random numbers.
E.g
If a folder has 1 excel doc inside of it, lets say its called Prices.xls and its 4Mb in size.
Then there is another 5 files with names like 2E4EB100 with no extention and its the exact same size as
the Prices.xls document if i rename one of the file 2E4EB100 to 2E4EB100.xls it opens fine in excel.
It makes me think its a temp file but its wasing lots of space! if there is 5 documents in afolder they all get duplicated.
There is not pattern in the duplication some are duplicated 3 times some even 5 and some only once.
shared drive with excel docs duplicating.
- hamin_aus
- Forum Moderator
- Posts: 18363
- Joined: 28 Aug 2003, 02:00
- Processor: Intel i7 3770K
- Motherboard: GA-Z77X-UP4 TH
- Graphics card: Galax GTX1080
- Memory: 32GB G.Skill Ripjaws
- Location: Where beer does flow and men chunder
- Contact:
Re: shared drive with excel docs duplicating.
http://support.microsoft.com/kb/814068
Excel creates these temporary files when users make changes. Then when users save, the temp files are saved with the name if the spreadsheet, and the old spreadsheet is deleted.
If the user saving the file does not have rights to delete the Excel doc, this might happen...
Excel creates these temporary files when users make changes. Then when users save, the temp files are saved with the name if the spreadsheet, and the old spreadsheet is deleted.
If the user saving the file does not have rights to delete the Excel doc, this might happen...
Re: shared drive with excel docs duplicating.
Yip I figured it would be that Cus i did change the permissions, the users had permission to create folders and files but did notjamin_za wrote:http://support.microsoft.com/kb/814068
Excel creates these temporary files when users make changes. Then when users save, the temp files are saved with the name if the spreadsheet, and the old spreadsheet is deleted.
If the user saving the file does not have rights to delete the Excel doc, this might happen...
have permission to delete.
But what puzzled me is excel normally does this locally in the temp folder also making the the file hidden with funny characters like .%3453456.xls
Thanks for the help jamin.