Avatar of LockDown32
Flag 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?
Windows 10SBSMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon
Edward Pamias

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 Henson

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

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?
Your help has saved me hundreds of hours of internet surfing.

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)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

Additional research yeilds this to be the correct answer.