I'm using Office 365ProPlus and have added a macro to my excel sheet to determine the last save date of this excel XLSM file. (using FileDateTime)
On my local PC this works as designed.
After uploading the file into sharepoint in the cloud, I have two option
Does anybody know how I can get Excel to work properly with Macros if the file is stored in the cloud ?
Excel Online doesn't support running Macros:
Thanks for the quick response.
I learned now that it doesn't work with Excel online at all.
What's about local Excel with a file located in Sharepoint Online ? Should this work ?
It worked for me.
When you recorded your macro where did you store it?