Home

Macro in Excel on Sharepoint Online do not work

Highlighted
Reiner Burton
New Contributor

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.

 

After uploading the file into sharepoint in the cloud, I have two option

  • Open the file in the browser --> Excel does not even recognice the Macro
  • Open the file in Excel           --> Excel recognices the Macro but returns as last save date 01.01.1900

 

Does anybody know how I can get Excel to work properly with Macros if the file is stored in the cloud ?

 

Thanks Reiner

  • Office 365
  • SharePoint
3 Replies

Re: Macro in Excel on Sharepoint Online do not work

Re: Macro in Excel on Sharepoint Online do not work

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 ?

Cheers

Re: Macro in Excel on Sharepoint Online do not work

It worked for me.

 

When you recorded your macro where did you store it?

MacroStore.PNG

Related Conversations
Custom markup in SharePoint calculated columns
Chris McNulty  in  SharePoint  on
11 Replies
GA: Microsoft PowerApps and Flow
Chris McNulty  in  SharePoint  on
41 Replies
Updated: Online Interactive Guides
Maddie Egan  in  Online Interactive Guides  on
45 Replies
Announcing Power BI Web Part Preview for SharePoint
Chris McNulty  in  SharePoint  on
31 Replies
Rollout of SharePoint Communication Sites to First Release?
John Wynne  in  SharePoint  on
12 Replies