Link to home
Start Free TrialLog in
Avatar of LockDown32
LockDown32Flag for United States of America

asked on

Excel 2013 backup/temporary files

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?
Avatar of Edward Pamias
Edward Pamias
Flag of United States of America image

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".
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.

Rob H
Avatar of LockDown32


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?
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)
Avatar of LockDown32
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Additional research yeilds this to be the correct answer.