Workaround for macros

Question

Hi,

I have a spreadsheet that is accessed by several people that we want to move online for ease, however it contains some very useful macros that won't work online. I'm also 99% sure I can't link a desktop sheet to an online sheet to pull the data through I need for the macros but wanted to ask in case anyone knew of any way to get round this?

Thank you,

Answer 1

Hi Tina Burdett,

Thank you for posting in this community and I am sorry for this inconvenience caused to you.

Sorry that Excel for the web doesn’t support VBA.

Reference: Work with VBA macros in Excel for the web (microsoft.com)

Unfortunately, there is no way to get around this. I understand your feelings and the inconvenience caused to you. To address your concerns, you may try to send feedback via the following portals to let the related programming team know this issue directly. Since they should be the quickest route to get your comments to the related programming developers’ears.

They read customer feedback daily.

1. Send feedback within Excel for the web App (Help>Feedback)
2. Feedback ·Community (microsoft.com)

Moreover, Power BI and Office script are helpful to work with Excel for the web. And you may give it a try.

For your information:

Data Visualization with Excel and Power BI | Microsoft Power BI

Introduction to Office Scripts in Excel (microsoft.com)

Best Regards,

May