Forum Discussion
Missing Edit in Excel option from Excel Online (Shared from Onedrive)
Thanks for the response Tanya.
A follow up question. I understand that we can't use Macro Enabled Workbooks online, however why is the Edit in Excel option missing? The option to download the Workbook is there, but I don't want a downloaded copy and want to edit the original and why would I be allowed to edit the workbook in Excel on my work PC but not at home?
Here's a picture of the same document accessed on my work PC. Note the option to Edit in Excel is available to me. When using my home PC it only provides me with the option to Edit in Browser.
I am interested in the answer to this as well. The "Edit in Excel" option recently disappeared for me. It used to be available when I opened a spreadsheet in browser, but now my only option is "edit in browser." Very frustrating.
From the testing we did we found the following results.
If a file is shared with an external user, who doesn't have an O365 account, then you'll only get the Edit in Browser option. If you want the edit in excel you'll need to sign into your O365 account or download the file. This poses a bit of an issue when sharing files with external users as most don't have an O365 account and there can be limited excel functionality with the web app. Macro's is a great example of where your limitations lay because to fully get the experience of a Macro then you do need to edit the file in excel.
I'd like to see the option show based on the version of excel that's running off your PC, not what version of O365 you have.
