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?