Why cant I edit Excel on OneDrive?

Why cant I edit Excel on OneDrive?

If a worksheet or presentation is locked for editing and can’t be edited in the Windows desktop applications, it may be that the file is already being edited by someone else, or they have the file checked out.

How do I enable editing in OneDrive in Excel?

Share files or folders

1. Select the files or folder you’d like to share.
2. Select Share .
3. Select Anyone with this link can edit this item and set the permissions: Select Allow editing if you want others to be able to edit the file.
4. Select how you’d like to share:

How do I edit an Excel file in OneDrive?

Click Open in Excel. In Excel, make the editing changes you want. On the File tab, click Save….Edit worksheet data in Excel for the web

1. Sign in to OneDrive.
2. Click the folder that contains the workbook you want to edit.
3. Click the workbook you want to change.

Why can’t I edit in Excel Online?

Make sure the file is not opened in Excel desktop, and then check if you are able to edit with Excel Online. Moreover, does the issue only occur with one specific file? Let her share with you some other files, and then check if you are able to edit them with Office Online.

Can’t open Excel file from OneDrive?

Step-by-Step

1. Right-click the blue cloud icon in the system tray then click Pause syncing.
2. Right-click the blue cloud icon in the system tray then click Exit.
3. Uninstall OneDrive for business.
4. Be sure all Windows and Microsoft critical updates have been run.
5. Restart your computer, if updates were performed.

How do I enable editing in Excel Online?

Share and collaborate with Excel for the web

1. Select Share.
2. Set permissions. Allow editing is automatically checked.
3. Enter the names or email addresses of who to share with.
4. Add a message (optional).
5. Select Send. Or, select Copy link to get a link to the file.

How do I open a OneDrive file in Excel?

Go to where the workbook is stored on your OneDrive, by following a link or by signing in at OneDrive.com. Click the workbook. Excel for the web opens the workbook. Use the ribbon interface to view and interact with the data.

Can you edit files on OneDrive?

When you click on a Word, Excel, PowerPoint, or OneNote file, OneDrive will automatically open the file in the online version of Office. To edit the file, click on Edit in the top right. Then, either choose Edit in Word or Edit in Word Online. This process is the same for PowerPoint, Excel, and OneNote Files.

Does OneDrive allow live editing?

The OneDrive system simply does not allow for simultaneous editing of the file. Access to these changes in the active won’t be updated and accessible until the file is closed down. the a new instance of the document will be launched from last the version of the file that was unchanged by the current active session.

How do I stop Excel from editing online?

To restrict editing to a sheet in Excel, use these steps:

1. Open the Excel document.
2. Click on File.
3. Click on Info.
4. On the right side, click the Protect Workbook menu.
5. Select the Protect current sheet option.
6. (Optional) Set a password to unlock the sheet.
7. Check the Protect worksheet and contents of locked cells option.