Office 365, Co-authors cannot autosave to online version - Is it VBA that is causing it?

[Newbuilder]

Hi

Problem: When this is saved on Sharepoint and people access it directly and then choose to open it in desktop mode, if more that one is co-authoring then both get told online saving is no longer available, discard or save local.

Is it my VBA coding that is causing this?

Any help grateful.

Have removed one sheet to get uploaded.

[superspud]

Hi,

I've not looked at your attached file but yes that could be the cause. One of the many missing features of the web app version of excel 365 is that doesn't support the creation, running, or editing of macros so if the users need to run the macros then they will need to download/open in the 'real' excel application which breaks the co-authoring.

[Newbuilder]

Hi,

I've not looked at your attached file but yes that could be the cause. One of the many missing features of the web app version of excel 365 is that doesn't support the creation, running, or editing of macros so if the users need to run the macros then they will need to download/open in the 'real' excel application which breaks the co-authoring.

I thought opening on web and then editing in desktop kept the coauthoring?