Mac Will Not Open Excel File Locked for Editing for Review

I am using Excel 2010 on Win 7 and I met a problem. I was trying to open up an Excel file just got a message saying my file is locked for editing by "username". Why did I get this error? After researching many solutions online, I am stumped and hope someone can assist figure this out.

Equally a frequent user of Excel application, y'all are bound to face errors similar this. Yous practise non have to exist panic if you incur such an editing mistake every bit it is mutual with Excel files and it can be stock-still.

Keep reading this commodity every bit it explains why the excel file is locked for editing and shows how to fix this error. Additionally, you can learn how to avoid this error adjacent fourth dimension.

Part i: Why is the Excel File Locked for Editing?

It will be easy to handle this trouble if you know the causes for Excel file being locked for editing. There are lots of causes can trigger this type of error:

• File in use or locked for editing error occurs when Excel fails to close properly, therefore, failing to save the file accordingly.

• The file could be opened past another user when open up in a shared network. In this case, y'all tin only open up in Read-Only manner and receive a notification when the file is prepare for editing.

• Sometimes, Microsoft Office may create a temporary file for your Excel, which has "~$" followed by the name of your Excel file. This will also trigger the error "filename.xlsx is locked for editing by "username"".

Function 2: How to Fix Excel File is Locked for Editing

This mistake can be easily solved. Before proceeding to the guide below ensure the Excel file is closed on all devices. In case the error persists, close the file for a while and reopen it to releases the lock on the file. Alternatively, you tin can ask for edit permissions on the file or wait for the file to exist airtight by the other user.

If yous are not successful then here is a elementary guide to accessing an excel file locked for editing.

Step 1: Keenly notation the file name and the file path. To brainstorm, launch the "Run" dialogue box by simultaneously property the "Windows" central and pressing "R".

Footstep 2: Search for the Microsoft Management Console by inputting "MMC" on the search bar and cull "File" and so "Add together/Remove Snap-in".

Pace 3: Select "Shared Folders" in the list of "Available Snap-ins" and click "Add" to add information technology to the "Selected snap-ins" list.

Step 4: On the "Select the computer you want the snap-in to manage" prompt, select the "Local figurer" option if you are logged in on the server or "Another computer" if you are logged in at a different computer. Search for the file location from this window.

Step 5: Proceed to select "Open up Files" and click "OK".

Step 6: Finally, aggrandize the "Open Files" list, sort the list preferably past author/user name to locate the file. Right-click on the file and select "Close Open file" from the options.

Now you can edit the excel file having disconnected the user who had it open. Exit Excel and open up the file afresh to edit.

Part 3: How to Avoid the State of affairs "Excel File Locked for Editing"

Having known how to set up the error, be sure of how to avoid it adjacent fourth dimension. Using these tips, you are free to piece of work on your files across multiple users simultaneously.

Tip one. Utilize Excel Version That Supports Co-authoring

Use the Excel version that supports co-authoring such equally Excel for the web, Excel for Android, Excel for iOS, Excel for Office 356 and Excel for Office 365 for Mac.

However, the terminal ii versions require y'all to sign in to an Office account with an Office 365 subscription. For best co-authoring feel, you lot are advised to all use Excel Online.

Tip two. Upload the File to Cloud

SharePoint, OneDrive for Business or One Bulldoze serve the best for co-authoring and easy accessibility. Every bit a result, in that location is no "locked". Notwithstanding, co-authoring is not supported on cloud locations, local folders, server paths and SharePoint On-Premises sites.

Tip 3. Cheque the File Formats

Y'all must consider file formats for co-authoring to be sure its uniform with all users. The recommended formats are .xlsx, .xlsm or .xlsb for Windows and Mac users.

• To gear up the file format for Windows, click the File>Relieve Every bit>Scan>Relieve as type and select the above formats.

• For Mac users click the File, Save Equally options and select the .xlsx, .xlsm, or .xlsb formats every bit well.

Tip 4. Check One Drive Sync App

For One Drive sync app users, ensure it'due south the latest version for each user and not paused at any given time.

Tip 5. Get Rid of Unsupported Features

Finally, in case at that place is a feature non supported by co-authoring, at that place will be the "locked" mistake. Therefore, yous will have to turn off the Shared Workbook feature and open up the workbook instead of the snapshot from SharePoint.

Tip: What if Your Excel File is Locked for Editing with A Password?

The above solutions didn't fix the problem for yous? There is a possibility that your Excel file is locked for editing with a password. You probably set a password but forgot information technology or set it by a co-author without your knowledge. At that place is a definite solution as well.

Passper for Excel can remove all editing restrictions on your worksheet/workbooks without losing or affecting your original data. The programme is innovatively designed by iMyFone team, which is trusted and recommended by many reputable review sites like Macworld, PCWorld, techradar, Cult of Mac, and etc. Therefore, it's completely secure to use this program.

Some important features of Passper for Excel are listed below:

All editing and formatting restrictions on your Excel worksheets and workbooks can be removed within seconds.

The advanced technology guarantees a 100% success rate.

The program is unproblematic to apply. Unlock your locked for editing Excel file in just 3 steps.

File types like .xls, .xlsx, .xlsm, .xltm, .xlsb and etc are supported past this tool.

Here is a simple procedure to follow to remove the restrictions from Excel Worksheet/Workbook.

Download and install Passper for Excel software and launch it on your estimator.

Free Download for Win 10/viii.1/eight/vii/XP

Pace 1 Click the "Remove Restrictions" option on the homepage.

Pace 2 Upload the password-protected Excel file to the software past clicking the "Select a File" push.

Footstep iii Click on "Remove" to showtime the process. Simply within seconds, the restrictions will be removed.

In order to help you have an intuitive agreement of the whole process, you can watch the video guide below:

thompsontors1977.blogspot.com

Source: https://passper.imyfone.com/excel/excel-file-locked-for-editing/

Share this post