Forum Discussion
Missing Edit in Excel option from Excel Online (Shared from Onedrive)
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.