Sharepoint -- Shared Marco-enabled Excel Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2157698%22%20slang%3D%22en-US%22%3ESharepoint%20--%20Shared%20Marco-enabled%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2157698%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EWe%20have%20an%20macro-enabled%20excel%20spreadsheet%20that%20is%20uploaded%20to%20the%20sharepoint%20drive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20it%20is%20not%20able%20to%20be%20'shared'.%20Once%20a%20user%20goes%20in%2C%20when%20an%20another%20user%20attempts%20to%20go%20in%2C%20they%20get%20a%20pop%20up%20message%20asking%20whether%20they%20want%20to%20'read'%20the%20file%20only.%26nbsp%3B%20They%20are%20not%20able%20to%20enter%20the%20file%20to%20have%20edit%20access.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%26nbsp%3B%20We're%20using%20the%20'open%20in%20desktop'%20option%20b%2Fc%20the%20cloud%20excel%20version%20does%20not%20allow%20macros.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuestion%3A%26nbsp%3B%20Ho%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2157698%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi there,

We have an macro-enabled excel spreadsheet that is uploaded to the sharepoint drive.

 

However, it is not able to be 'shared'. Once a user goes in, when an another user attempts to go in, they get a pop up message asking whether they want to 'read' the file only.  They are not able to enter the file to have edit access.

 

Note:  We're using the 'open in desktop' option b/c the cloud excel version does not allow macros.

 

Question:  Ho

 

0 Replies