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 able to tell me why this happens and how to fix it?
Thanks
Sorry about the lack of information previously. I am new to using macro and SharePoints.
- What do you define as "stops working?" Never starts, errors out? - never starts
- What is your macro supposed to do? - Its just a basic Macro designed to clear all the data in the spreadsheet
- Are you opening the document in Excel Online? Excel Online doesn't support macros. - its the online version of excel. If Excel online doesn't support macros that may be why its not working
- 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. The macro is ran by the user selecting. The macro is ran by the user pressing the 'clear data' button. I am not sure if this is an Open trigger or a startup trigger.
- Does your macro reference any local or network locations? - No
If the spreadsheet was opened in a SharePoint and then the user selected the edit in Excel option would the Macro work?
Cheers
If you open your Excel workbook in the Excel desktop client, your macro should have no issue running in the client.
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?
