0

Good Day,

I've reviewed the following questions Excel Macros in SharePoint and How to handle Excel sheets with macros and am still stumped.

So... We have an Excel Spreadsheet that is full of macros that we are trying to save to SharePoint. I realize now that macros are not supported by Office online, but when I open said Excel Spreadsheet in desktop app, the macros are still not working. Where might I be going wrong here?

Any assistance with this is greatly appreciated!

-Cheers! DS

4
  • What error message do you get? You should get a warning to trust the location, after that the macros should work fine... May 1 '20 at 14:57
  • You might also have to add your sharepoint URL to the trusted location of office settings May 1 '20 at 14:57
  • Thank you @RuneSperre do you know how I would do this as an admin for all users? Also, I don't get a pop up at all, it just doesn't run the macros.
    – Mumford451
    May 1 '20 at 15:21
  • Group policy, but you should be able to do it for yourself to test: docs.microsoft.com/en-us/deployoffice/privacy/… May 1 '20 at 17:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.