We help IT Professionals succeed at work.

Excel 2013 backup/temporary files

132 Views
Last Modified: 2018-02-06
It is a SBS 2011 Server. Windows 10 Workstations. Office 2013 Professional.When I look at Computer Management=>Open Files on the server I see whenever someone has a spreadsheet open it also opens one with the same name but a ~ in the first position. i.e. the user opens up a spreadsheet "My Spreadsheet" I see two files opened on the server. The second being "~y Spreadsheet".

  What is that file with the ~? A backup for recovery purposes? anyway... I asked the question before and never got an answer. I don't want the ~ file on the server. I think it is causing problem. I want it on the C: drive. What is that file and where, in Excel 2013, can I tell it where to keep it?
Comment
Watch Question

Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Commented:
I am looking at my excel, I have AutoRecovery File Location , Default File Location, and Server drafts location. What I would do is go onto one of the workstations and see the file locations. Usually click "File" go to "Options" then go to "Save".
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
I believe the "~Filename" file is always created in the same directory as the original file.

When the original file is closed the "~File" should disappear. I suspect but cannot say for certain that it is used in the case of AutoRecovery when it will be saved to the AutoRecovery location specified in Excel Options.

Thanks
Rob H
LockDown32Owner
Top Expert 2016

Author

Commented:
I am first going to correct myself. It is ~$ and that does appear to be the auto-recovery file but ... I got on one workstation and looked at the Save options. It was set to C:\Users\User\Roaming\Microsoft\Excel. So I opened that location and there was nothing it in. I then opened three spreadsheets on the server and went back to the server and watched the open files. and watched. and watched. Never did I see a ~$ file for any of the three files I had open on that workstation not did I see then in that location on the C: drive.

Well... it took a lot longer that the 10 minutes (save auto recovery every) but they did finally show up on the C: drive and still have not shown up up the server. So on this one particular workstation if does appear that the "Options" work. What I don't understand is why any ~$ files are on the server because all the Excel settings are the same and none of them specify saving the auto recovery on the server. Any ideas?
LockDown32Owner
Top Expert 2016

Author

Commented:
Still no definitive answer. The "backup files" used to recover are in C:\Users\user\appdata\roaming\excel

If you Google it the ~$ files in the same folder as the documents (and this also refers to Word, Excel and Outlook files) some call them "Lock" files used for locking and others refer to them as "Temporary" files to hold temporary information (whatever that is)
Owner
Top Expert 2016
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
LockDown32Owner
Top Expert 2016

Author

Commented:
Additional research yeilds this to be the correct answer.