Excel 2010 deleting master file and not creating ~$file for end user
-
Friday, June 29, 2012 11:24 AM
We have a strange issue with Excel Deleting a Master copy of a file.
Heres the scenario...
Laptop running Windows 7 with Office 2010
User opens a file on a network share from a laptop.
User works on file.
At some point user disconnects the laptop from docking station while Excel is still open and takes laptop home.
At this point our audits show Excel renames the master file to an XXXXX.tmp file
When the user comes in the next day and re-opens Excel it deletes the xxxxx.tmp and of course the Master file has been renamed to this so the file is gone from the network share?
Any ideas ?
Of course we have told the user to save and close properly before shutting down but you know users?
In testing........
Doing some testing we created a test file called test.xlsx and when opened a ~$test.xlsx file in the shared folder. When we modify that file and then save it we see a xxxxx.tmp file created and then the master test.xlsx is modified.What we dont see from the end user is that when he opens the original file no ~$ file is being created? The user has rights to modify anything in the folder also.
All Replies
-
Tuesday, July 03, 2012 2:50 AMModerator
Hi,
Base on the test, ~$ file will not be created if you open a shared workbook. You can firstly confirm if the original workbook is a shared workbook:
To the .tmp issue, we can follow these steps to determine which could be the reason:
1. Disable Offline files feature in Windows 7 client.
2. Turn off Anti-Virus program temporary on the client.
3. Create a new Windows profile for test:
For Windows Vista/Windows 7:
http://windows.microsoft.com/en-us/windows-vista/Create-a-user-account
http://windows.microsoft.com/en-us/windows-vista/Fix-a-corrupted-user-profile
4. Excluded the shared folder from being indexed on the server. You can go into the server's Indexing Options and then configure the settings.
5. Create a new shared folder on other server.Sincerely
Rex ZhangRex Zhang
TechNet Community Support
- Marked As Answer by Rex ZhangModerator Friday, July 06, 2012 12:51 AM

