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...
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