Microsoft Visual Basic for Applications: "Automation error, Catastrophic failure" in SHARED workbook

Question

Last week we received an update going from Windows7 Excel 2010 to Windows 10 with the MS package 2016.

We had a SHARED Excel workbook with some simple macro's (nothing complicated). This worked fine for everybody.

After the update ones the workbook is opened by someone and changes are made and saved i got Microsoft Visual Basic for Applications: "Automation error, Catastrophic failure". VBA opens to debug, but because i'm working in a shared workbook there is nothing to see. This error keeps reapearing each time i open the workbook. Until someone opens the workbook who had nothing saved previously, removes all users and saves the workbook exclusive. At that point i can open the workbook, make it shared again and as long nobody is making any changes in the workbook i'll be able to open it in shared. 

During exclusive mode, no error appears and everithing is working fine. 

I tried a few things that i could find on the web but nothing worked so far (Add-in's, Manual calculation, binary workbook,...). This workbook is used by many people over different services, some having issues, some don't. This problem occures now also by 1 user who diden't update yet and works with Excel 2010, Windows 7.

My point of view:  this is realy a sharing issue. But how can i solve it ? Does excel stores a "working copy" on the my workstation during editing wich can cose the problem by reopening ?

Answer 1

Hi Id suggest you to use the live chat, to talk to an Microsoft agent.

https://support.office.com/en-us/home/chat

Answer 2

I would suggest that you should post simultaneously to MSDN forum also as this will increase chances of getting the fast answer to this query. So, your question will be on two forums - This and MSDN. Experts on both forums will assist you giving you wider reach.

https://social.msdn.microsoft.com/Forums/en-US/...