File Sharing Problems

Fix Excel 2010 Temporary Lock Files Disappearing on a Network Drive

Adam DavisAdam Davis Nov 22, 2026 868 views

Question details

Determine why Excel 2010 temporary lock files disappear after 90 minutes while network workbooks remain open.

Excel 2010 Temporary Lock File Disappears on a Network Drive
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.
Before you start

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.

Solution 1Recommended

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.

1
Test an XLSX workbook

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.

2
Test another location

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.

3
Compare computers

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.

4
Check access from another computer

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.

Compare File Types and Storage Locations
Use test workbooks: Do not have two people edit a production workbook during testing; concurrent changes can conflict.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLSX and XLS formatsAccess workbooks stored on a network driveUse a free, lightweight office suite for everyday tasks
microsoft office alternative - wps office

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.