Who locked the file

To do that, go to the Review tab. If Protect Workbook is highlighted, click it to turn off protection. Enter the password if prompted. If possible, remove restricted access. Step 3: Make sure everyone uses a version that supports co-authoring. Note: Excel does not support co-authoring. Windows: If possible, remove password encryption or restricted access from the file.

Mac: If possible, remove password encryption from the file. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Type a new name for the file and choose a storage location for the new file. On your iPhone, use the backspace key to delete the current name, and then enter the new one. Double-tap the Home button, touch the app, and then swipe up.

This will close the app and any running processes associated with it. Double-tap the Home button. If the app still appears to be open, touch the app icon, and then swipe up. Tap File on your Android tablet or tap the file icon on your Android phone. Open the multitasking screen, touch the Office app, and then swipe to the left or right. Open the multitasking screen. If the Office app still appears, touch the app icon, and then swipe to the left or right to close it.

Tap File on your Windows tablet or tap the file icon on your Windows phone. On your tablet, give the copy a name, choose a location for the new file, and then tap Save a copy. On your phone, browse to the location where you want to save the file, tap the right arrow , enter a file name, and then tap the Save icon. Look for instances of the Office app, select each instance, and then tap End task to close it. Press and hold the back arrow on the bottom of your screen.

You will see the apps that are currently running on your device. Open the file. Tap Save or tap Duplicate.

Hold down the power button. When the slide to power off screen appears, release the power button. Press the Home button until the app quits. It will quit after a few seconds. On the File tab, tap Save As. Choose a location for the new file, give it a name, and then tap Save. Create a new Access database on a network drive or open an existing database from a network drive.

Close it. Databases opened on a network drive appear to always be opened for exclusive access. Once one person has opened a database, others can't--even when opening for shared access. Reverting to the prior version This problem seems specific to databases located on a network share. For databases on a local machine, there is no issue.

Was this discussion helpful? Yes No. Sorry this didn't help. Thanks for your feedback. Use the application feedback command within Access to send in your comments to the Dev Team. I now see another similar thread in this forum with similar symptoms. Was this reply helpful? We have found the culprit for our problem! My team have found that the problem was in security update for MS office KB You can now find all the information regarding this latest bug, including the workaround at.

Here is the fix that worked for me regarding the shared MSAccess database locked file issue.