Hello all. I have a weird issue I was hoping somebody could shed some light on. I have about a half-dozen workbooks with various macros in them. 3 out of the 4 people that use these workbooks experience no issues. The 4th person gets a Run-Time Error 13 whenever they try to close any of these workbooks. Everything was working fine until they tried to share a workbook and their computer locked up on them. Ever since then they have received the error. They logged onto a different computer and it works fine so it would seem it has something to do with their computer. We are all using Office 2010 on Windows 7 machines.

I think it has something to do with the workbooks that open the same source doc. I have 2 different workbooks that we use as data analysis tools. One of the macros opens up the source doc whenever either of these tools is opened. When 1st tool is opened the source doc opens and all the formulas come back with the #VALUE error. When the source doc is manually opened and recalculated the tool works fine. When the 2nd tool is opened same issue. Only when they try to manually open the source doc it says the file path doesn’t exist... but again nobody else is having this issue and the code to open the source doc is in the same in both tools. Help me Excel community! You're my only hope.

Does anybody have any recommendations on where I can even start trying to figure this out?