Hi, this is such a strange one I had to post a thread (not something I've done before, so forgive me if I make any errors).
All our users are on Office365 (installed locally, not the web version). Most users are on Win 10.
My boss has a macro-enabled template that is used by multiple staff. It's contains dozens of VBA macros, most of which are assigned to buttons (not form controls). It also contains links to an XML data source using powerquery. The users open the template and as part of the workflow a copy is saved out to a central storage for each job as an .xlsm file.
As of this morning, all users are getting an error message when they try to click any of the buttons (see below). It looks like there was a network drop this morning and one of the users had the template open at the time, leading to some kind of corruption (we think). The macros are all present and correct and still work if you run them individually, the data queries all work too. It is just anything linked to a button is throwing up this error.
The really perplexing issue is that if a user tries to open a previously saved file, they also get this error when they click on one of the buttons. I can understand that the template may have been corrupted or damaged in some way, but how could it affect literally hundreds of previously created files that were not open at the time of the network blip?
We have other macro-enabled templates that are used on similar workflows with macros assigned to buttons, they are still working as normal (thank goodness).
The template is being rebuilt using previous versions (stored elsewhere). I was just wondering if anyone else has experienced anything like this? Any insights into how this could happen and how it could be fixed without having to recreate the file from scratch would be greatly appreciated.
Many thanks
Helen
All our users are on Office365 (installed locally, not the web version). Most users are on Win 10.
My boss has a macro-enabled template that is used by multiple staff. It's contains dozens of VBA macros, most of which are assigned to buttons (not form controls). It also contains links to an XML data source using powerquery. The users open the template and as part of the workflow a copy is saved out to a central storage for each job as an .xlsm file.
As of this morning, all users are getting an error message when they try to click any of the buttons (see below). It looks like there was a network drop this morning and one of the users had the template open at the time, leading to some kind of corruption (we think). The macros are all present and correct and still work if you run them individually, the data queries all work too. It is just anything linked to a button is throwing up this error.
The really perplexing issue is that if a user tries to open a previously saved file, they also get this error when they click on one of the buttons. I can understand that the template may have been corrupted or damaged in some way, but how could it affect literally hundreds of previously created files that were not open at the time of the network blip?
We have other macro-enabled templates that are used on similar workflows with macros assigned to buttons, they are still working as normal (thank goodness).
The template is being rebuilt using previous versions (stored elsewhere). I was just wondering if anyone else has experienced anything like this? Any insights into how this could happen and how it could be fixed without having to recreate the file from scratch would be greatly appreciated.
Many thanks
Helen