Forum Discussion
Macro in Excel on Sharepoint Online do not work
Hi, 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. Aft...
It worked for me.
When you recorded your macro where did you store it?
Pieter Veenstra I am having a similar problem, which of the 3 locations would be best to store the macro?
My gut says that keeping it 'local' and "This Workbook" would be the best location. Do you agree?
ptstockley Running Excel Macros is at least questionable. You could look at using Power Automate with running scripts in Excel. This is something that is still very new and in Preview but it could be interesting.
For more on this please have a look at the following post:
https://sharepains.com/2020/07/21/run-script-with-excel-in-power-automate/