Turn On Spreadsheet Release For Free

Select the table or PivotTable, then go to Table Tools Design > Refresh > Connection Properties. Then uncheck Refresh data when opening file. Inactivate an add-in that's causing the lock. Select File > Options > Add-Ins > Excel Add-ins > Go and then clear the check box for the add-in.

If the worksheet is protected, do the following: On the Review tab, click Unprotect Sheet (in the Changes group). Click the Protect Sheet button to Unprotect Sheet when a worksheet is protected. If prompted, enter the password to unprotect the worksheet.

Set up a shared workbook Click the Review tab. Click Share Workbook in the Changes group. On the Editing tab, click to select the Allow changes by more than one user at the same time. ... In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.

Open the file. Select File > Info. Select Protect Workbook, point to Restrict Permission by People, and then select Restricted Access. In the Permissions dialog box, select the Restrict permission to this workbook check box, and then select More Options.

Share your workbook Select Share. Set permissions. Allow editing is automatically checked. Uncheck this if you only want to give permission to view the file, not edit it. ... Enter the names or email addresses of who to share with. Add a message (optional). Select Send. Or, select Copy link to get a link to the file.

Open the file. Select File > Info. Select Protect Workbook, point to Restrict Permission by People, and then select Restricted Access. In the Permissions dialog box, select the Restrict permission to this workbook check box, and then select More Options.

Unprotect an Excel worksheet Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.

The file might be locked because: The file is shared and another user is currently editing it. An instance of the Office app is running in the background with the file already opened. The file has been marked as Final and can no longer be updated.