Forum Discussion
Macro not working
I have recently created a Excel spreadsheet which has Macro . The Macro works fine on the desktop version of Excel, but when I upload the spreadsheet onto a SharePoint it stops working is anybody ab...
There's a lot more information you'll have to provide for us to weigh in on that.
- What do you define as "stops working?" Never starts, errors out?
- What is your macro supposed to do?
- Are you opening the document in Excel Online? Excel Online doesn't support macros.
- Does your macro use an Open trigger, or something like it? If your macro-enabled spreadsheet is a template, SharePoint doesn't handle startup triggers on template documents very well.
- Does your macro reference any local or network locations?