Excel 2013 backup/temporary files

LockDown32
LockDown32 used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

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?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

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:
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.
LockDown32Owner
Top Expert 2016

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial