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?
LVL 15
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Edward PamiasTeam Lead RRS DeskCommented:
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 AnalystCommented:
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
LockDown32OwnerAuthor 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?
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

LockDown32OwnerAuthor 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)
LockDown32OwnerAuthor Commented:
The term for this file is a "owner file". Some refer to it as a "Lock File". It essentially lets other users who try and open the file know who already has it opened.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LockDown32OwnerAuthor Commented:
Additional research yeilds this to be the correct answer.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 10

From novice to tech pro — start learning today.