Excel Macros does not work in excel web version. -Sharepoint Case

Question

I have some issues regarding excel macros that cannot be run in the web version of excel instead of the desktop version. when I open the file in web version, there's a pop up "Links DisabledLinks to external workbooks are not supported and have been disabled"is this the main cause of this issue? if yes, I have tried to remove the link in the original file by clicking Data>Edit Links>Break a Link, but this does not work after I reupload and open the file on the web version. Unfortunately, we cannot give permission to an external user to open the file in desktop version due to company policy in avoidance of file duplication. I hope you can help me in this. Thank You

Answer 1

Hi Aldy Setiawan,

Thanks for posting your issue in this community.

Regarding to your description, you cannot open Excel macros file in the web but works fine in app and get the error. If so, I would like to explain that Excel workbook with macro-enabled does not support open in a browser window. Please check this Official article: Differences between using a workbook in the browser and in Excel That’s why you get the prompt and cannot run the macro in the web. 

If you wanna run the macro in Excel, you need to open it in app as expected.

Besides, if you really want to open Excel macro file in the web, we sincerely recommend you share this in Excel UserVoice, you can see multiple users have share their ideas there, Microsoft will keep monitoring there, and your good ideas will be very helpful for the dedicated engineers in Microsoft to improve the services, which also help benefit more users once this idea can be accepted by the product team.

We appreciate your understanding and cooperation.

Best regards,

Gloria

Answer 2

Thank You Gloria for your answer.