Hi All,
This is a bit of an unusual one, so I apologise for the poor title and if this is in the wrong part of the forum.
So I have created a spreadsheet containing a number of different macros, it's being used more or less as a front end for a database. This document is used by 24 of my colleagues all day every day and has been performing smoothly until recently.
All of a sudden (with no changes being made to the document) 3 of my colleagues have major issues with this document and everyone else remains unaffected. The issue occurs at different times as I will go on to explain but excel decides to completely crash (not responding) it then closes and tries to recover the workbook as you'd expect. This sometimes happens shortly after opening with no VB running at all or sometimes when running a particular piece of code.
I've been in touch with my companies IT dept to try and find the cause but I'm starting to wonder if it could be something to do with the document? I've tried to take a look at task manager and it doesn't appear to be short on memory (even when running the macros that crash excel).
*Edit*
I've just had some feedback from our IT dept who are telling me that a file called FM20.dll is causing excel to crash. I'm just googling this now to find out how to deal with it, but I've not had any experience with it before.
I'm hoping someone may be able to point me in the right direction to help me trouble shoot this bizarre problem. As always any input is greatly appreciated.
Thanks in advance
Connor