How To Unlock Excel Sheet For Editing

Excel for iPad Word for iPad PowerPoint for iPad Excel for iPhone Word for iPhone PowerPoint for iPhone Word for Android tablets Excel for Android tablets PowerPoint for Android tablets Excel for Android phones Excel Mobile PowerPoint for Android phones PowerPoint Mobile Give-and-take for Android phones Give-and-take Mobile More...Less

When you lot try to open a Excel workbook, PowerPoint presentation, or Discussion document on your mobile device, you might receive a message stating that the file is locked for editing by another user. Typically, you volition be able to open the file equally read-but, only you won't be able to edit it.

The file might be locked because:

The file is shared and some other 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 equally Terminal and can no longer exist updated.

In some situations, you can use your mobile device to unlock the file and continue editing it.

Note:If the Office file is password-protected, yous won't be able to open up information technology without supplying the password. There is no style to circumvent password protection.

Another user is editing the file

If someone is currently working on the file, you can either wait for that person to close it, or you can create a re-create of the file and enter your changes in the copy. (Alternatively, y'all could switch to an app that allows multiple authors to piece of work on a file simultaneously.)

Employ the following procedures to create a copy on your mobile device. If yous choose to enter your changes in a copy, information technology's a practiced idea to use tracked changes so that you lot can easily move your changes to the shared file when it becomes bachelor. You can turn on tracked changes on the Review tab.

Tip:If you're trying to edit an Excel file at the aforementioned time every bit someone else, make sure that everyone uses a version of Excel that that supports co-authoring.

The Office app is running in the background

If the file is non shared on a network or if you are certain that no 1 is currently editing it, then an instance of the Role app with the file open might be running in the groundwork.

The file is marked as Terminal

Function includes a file protection characteristic that allows authors to mark a file equally Final. This locks the file, preventing any further editing. You can easily plough off this characteristic in the Office applications; however, you tin can't turn information technology off from your mobile device. If an Function file is marked Last, you will need to brand a copy to enter your changes from your mobile device.

Open the file.
Tap the file icon .
On your iPad, tap Name or Indistinguishable. The Save As window opens. If you take any awaiting changes, you lot will be asked whether yous want to apply them to the both the original and duplicate copy or the indistinguishable copy just. Brand your option.
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, then enter the new one.
Tap Save or tap Indistinguishable.

Double-tap the Home push, touch the app, and then swipe up. This will shut the app and any running processes associated with information technology.

If for some reason the app is unresponsive and can't be closed, yous can force it to close.

Hold down the ability push button.
When the slide to power off screen appears, release the ability push.
Press the Home button until the app quits. (It will quit after a few seconds.)
Double-tap the Domicile button. If the app still appears to be open, impact the app icon, and then swipe up.

Open up the file.
Tap File on your Android tablet or tap the file icon on your Android phone.
On the File tab, tap Save As.
Cull a location for the new file, give it a name, and then tap Save.

Open the multitasking screen, touch the Office app, and then swipe to the left or right. This will close the app and any running processes associated with it.

If for some reason the app is unresponsive and tin can't be closed, you can close information technology from the Settings app.

Tap the Settings app to open it.
Tap Apps.
In the upper-right corner, tap Running.
Tap the app.
Scroll downward and tap Force Stop or Stop.
You lot will see a confirmation message. Tap OK.
Open the multitasking screen. If the Role app even so appears, touch the app icon, and then swipe to the left or right to close information technology.

Open the file.
Tap File on your Windows tablet or tap the file icon on your Windows phone.
Tap Salve.
Tap Salve a copy of this file.
On your tablet, give the copy a name, choose a location for the new file, and and so tap Save a copy. On your phone, scan to the location where you want to salve the file, tap the right pointer , enter a file name, and then tap the Save icon .

On your tablet:

Press and hold the Windows logo cardinal on the lower-left corner of your screen.
Tap Chore Manager.
Wait for instances of the Role app, select each instance, and then tap Cease task to close it.

On your Windows phone:

Press and hold the dorsum pointer on the bottom of your screen. You volition encounter the apps that are currently running on your device.
Shut the Office app by tapping the x in the upper-right corner of the app.