Fix Excel 2010 Temporary Lock Files Disappearing on a Network Drive
Question details
Determine why Excel 2010 temporary lock files disappear after 90 minutes while network workbooks remain open.

- Product
- Microsoft Excel 2010
- Device & OS
- Windows (version not provided)
- Scenario
- Multiple users access macro-enabled workbooks stored on a domain network drive.
- Observed behavior
- The temporary owner file, such as ~$filename.xlsm, disappears after approximately 90 minutes, and other users can then edit the workbook while it is still open.
Coordinate the test with other users so they do not edit the affected workbook at the same time. Note the workbook path, the time it is opened, and when its ~$ owner file disappears.
Compare File Types and Storage Locations
Use controlled tests to determine whether the behavior is tied to XLSM files, the network share, or a particular computer.
The ~$ file is an owner file; its disappearance alone does not establish why simultaneous editing is possible. Testing other files and locations can help narrow down the cause.
Create a separate test workbook in Excel using File > Save As and choose Excel Workbook (*.xlsx). Open it from the same network folder and check whether its ~$ file remains after 90 minutes.
Use File > Save As to place a separate test workbook in another network share, then repeat the 90-minute check. Also test a local folder to compare behavior, although a local test does not reproduce network sharing.
Repeat the network-share test on another computer or Windows version, if available. Record the Excel and Windows versions, file type, location, and time the owner file disappears.
After the 90-minute mark, have a second user open the test workbook from the same network path and record whether Excel offers read-only access or allows editing.

Investigate Network Locking With an Administrator
Use this approach if the issue persists on the network share or affects multiple workbooks.
Work With Excel Workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easier to move everyday workbook tasks. It does not fix Excel 2010 or network locking issues.

Frequently Asked Questions
What is the ~$ file next to my Excel workbook?
It is a temporary owner file associated with an open workbook. Its presence or absence alone does not explain the state of all network file locks.
How can I tell whether the problem only affects XLSM files?
Create a separate XLSX test workbook with File > Save As, open it from the same network folder, and check its owner file and access from another computer after 90 minutes.
Should I manually recreate the missing ~$ file?
No. Creating a file with the same name is not a reliable way to restore Excel or network locking. Ask an administrator to investigate the server session and open-file state instead.
Does WPS Office fix Excel 2010 network locking?
No. WPS Office is an alternative for working with spreadsheets, but the Excel 2010 and network-share locking issue requires separate investigation.




