Home

Missing Edit in Excel option from Excel Online (Shared from Onedrive)

%3CLINGO-SUB%20id%3D%22lingo-sub-157310%22%20slang%3D%22en-US%22%3EMissing%20Edit%20in%20Excel%20option%20from%20Excel%20Online%20(Shared%20from%20Onedrive)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-157310%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%20I%20have%20an%20employee%20who's%20sharing%20an%20Excel%20with%20Macro%20with%20edit%20permissions%20with%20a%20customer%20(not%20on%20our%20network)%20and%20myself%20(who's%26nbsp%3Bon%20the%20network).%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20This%20file%20does%20not%20allow%20for%20Editing%20in%20Excel%20for%20the%20customer%20and%20only%20in%20the%20browser%20(See%20screenshot)%3C%2FP%3E%0A%3CP%3E2.%26nbsp%3BThis%20file%20does%20allow%20Editing%20in%20Excel%20when%20I%20access%20through%20our%20network%3C%2FP%3E%0A%3CP%3E3.%20The%20file%20does%20not%20allow%20for%20Editing%20in%20Excel%20when%20I%20access%20our%20O365%20platform%20from%20home.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20can't%20seem%20to%20find%20any%20documentation%20on%20why%20the%20Edit%20in%20Excel%20option%20is%20missing.%26nbsp%3B%20Can%20someone%20please%20help%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20image%20below%20is%20a%20little%20crude.%26nbsp%3B%20Note%20the%20Green%20box%20that%26nbsp%3Bprovides%20the%20option%20to%26nbsp%3B%22Edit%20in%20Browser%22%20and%20the%20Edit%20in%20Excel%20is%20missing.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F28495i7120E343DFCC7B21%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Edit%20in%20Excel.png%22%20title%3D%22Edit%20in%20Excel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-157310%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Macro%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-356227%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Edit%20in%20Excel%20option%20from%20Excel%20Online%20(Shared%20from%20Onedrive)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356227%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EWe%20have%20the%20same%20problem%20but%20in%20our%20case%20from%20an%20different%20perspective.%3C%2FP%3E%3CP%3EWe%20all%20have%20the%20same%20access%20(within%20the%20network)%20so%20we%20can%20all%20access%20the%20files%2C%20however%3B%20Without%20the%20%22Edit%20Workbook%22%20option%20the%20file%20is%20locked%20by%20the%20first%20person%20opening%20it.%20Before%2C%20a%20number%20of%20people%20could%20open%20the%20workbook%20and%20then%20anyone%20could%20choose%20to%20edit.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20get%20the%20%22Edit%20Workbook%22%20option%20back%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-160741%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Edit%20in%20Excel%20option%20from%20Excel%20Online%20(Shared%20from%20Onedrive)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-160741%22%20slang%3D%22en-US%22%3E%3CP%3EFrom%20the%20testing%20we%20did%20we%20found%20the%20following%20results.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20a%20file%20is%20shared%20with%20an%20external%20user%2C%20who%20doesn't%20have%20an%20O365%20account%2C%20then%20you'll%20only%20get%20the%20Edit%20in%20Browser%20option.%26nbsp%3B%20If%20you%20want%20the%20edit%20in%20excel%20you'll%20need%20to%20sign%20into%20your%20O365%20account%20or%20download%20the%20file.%26nbsp%3B%20This%20poses%20a%20bit%20of%20an%20issue%20when%20sharing%20files%20with%20external%20users%20as%20most%20don't%20have%20an%20O365%20account%20and%20there%20can%20be%20limited%20excel%20functionality%20with%20the%20web%20app.%26nbsp%3B%20Macro's%20is%20a%20great%20example%20of%20where%20your%20limitations%20lay%20because%20to%20fully%20get%20the%20experience%20of%20a%20Macro%20then%20you%20do%20need%20to%20edit%20the%20file%20in%20excel.%26nbsp%3B%20%3CBR%20%2F%3E%3CBR%20%2F%3EI'd%20like%20to%20see%20the%20option%26nbsp%3Bshow%20based%20on%20the%20version%20of%20excel%20that's%20running%20off%20your%20PC%2C%20not%20what%20version%20of%20O365%20you%20have.%3C%2FP%3E%0A%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CHR%20%2F%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-160707%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Edit%20in%20Excel%20option%20from%20Excel%20Online%20(Shared%20from%20Onedrive)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-160707%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20interested%20in%20the%20answer%20to%20this%20as%20well.%26nbsp%3B%20The%20%22Edit%20in%20Excel%22%20option%20recently%20disappeared%20for%20me.%26nbsp%3B%20It%20used%20to%20be%20available%20when%20I%20opened%20a%20spreadsheet%20in%20browser%2C%20but%20now%20my%20only%20option%20is%20%22edit%20in%20browser.%22%26nbsp%3B%20Very%20frustrating.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-157865%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Edit%20in%20Excel%20option%20from%20Excel%20Online%20(Shared%20from%20Onedrive)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-157865%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20response%20Tanya.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EA%20follow%20up%20question.%26nbsp%3B%20I%20understand%20that%20we%20can't%20use%20Macro%20Enabled%20Workbooks%20online%2C%20however%20why%20is%20the%20Edit%20in%20Excel%20option%20missing%3F%20The%20option%20to%20download%20the%20Workbook%20is%20there%2C%20but%20I%20don't%20want%20a%20downloaded%20copy%20and%26nbsp%3Bwant%20to%26nbsp%3Bedit%20the%20original%20and%20why%20would%20I%20be%20allowed%20to%20edit%20the%20workbook%20in%20Excel%20on%20my%20work%20PC%20but%20not%20at%20home%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere's%20a%20picture%20of%20the%20same%20document%20accessed%20on%20my%20work%20PC.%26nbsp%3B%20Note%20the%20option%20to%20Edit%20in%20Excel%20is%20available%20to%20me.%26nbsp%3B%20When%20using%20my%20home%20PC%20it%20only%20provides%20me%20with%20the%20option%20to%20Edit%20in%20Browser.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20323px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F28509iDF2B5B5932D5F6BF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Worbook%20Options.PNG%22%20title%3D%22Worbook%20Options.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-157644%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Edit%20in%20Excel%20option%20from%20Excel%20Online%20(Shared%20from%20Onedrive)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-157644%22%20slang%3D%22en-US%22%3EYou%20cannot%20edit%20macro%20enabled%20workbooks%20online%2C%20only%20with%20the%20desktop%20version.%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwork-with-macros-in-excel-online-98784ad0-898c-43aa-a1da-4f0fb5014343%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwork-with-macros-in-excel-online-98784ad0-898c-43aa-a1da-4f0fb5014343%3C%2FA%3E%3C%2FLINGO-BODY%3E
Brandon Little
Occasional Contributor

Hello,  I have an employee who's sharing an Excel with Macro with edit permissions with a customer (not on our network) and myself (who's on the network). 

1. This file does not allow for Editing in Excel for the customer and only in the browser (See screenshot)

2. This file does allow Editing in Excel when I access through our network

3. The file does not allow for Editing in Excel when I access our O365 platform from home.

 

I can't seem to find any documentation on why the Edit in Excel option is missing.  Can someone please help?

 

The image below is a little crude.  Note the Green box that provides the option to "Edit in Browser" and the Edit in Excel is missing.Edit in Excel.png

5 Replies

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. 

 

Worbook Options.PNG

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.


 


 


 

Hello!

We have the same problem but in our case from an different perspective.

We all have the same access (within the network) so we can all access the files, however; Without the "Edit Workbook" option the file is locked by the first person opening it. Before, a number of people could open the workbook and then anyone could choose to edit.

Is there a way to get the "Edit Workbook" option back?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies