Excel / Sharepoint Online Issues

Copper Contributor

I have an admin workbook that uses a Macro to take data out of two excel reports and display it in a table in the admin workbook, when developing and testing from my desktop it works fine, however I have now uploaded it to Sharepoint Online and I open it up in the app, as I am aware Macros don’t work in the browser, and the Macro runs fine but then I save and close the workbook and then open it back up all the data is not there and has been replaced with #VALUE

1 Reply
hello,

If you have a copy the Excel workbook on your desktop, you still have your data intact.

I believe there is no need to upload workbook that contains macros to Excel online since Excel online doesn't support it.


Cheers