I built an Excel workbook (CPD.xlsb for reference). It has extensive VBA programming, including code that executes when the file is opened (Private Sub Workbook_Open() etc.).
The workbook has been deployed to nearly 70 users who have been running it for 8 months. In that time, it has run on some combination of Windows 7 or 10, 32-bit or 64-bit, and Office 2013 / 2016 (a.k.a. 365 ProPlus). Nearly all of the users are now on Win10/Excel2016, and it works on all of the OS/Office combinations, in 7 countries, on 4 continents . . .
. . . except for one guy. (There's always one, right?)
He has Win10/Excel2016 like most of us. He can run other VBA-laden Excel workbooks that I have built without a problem. But, whenever he opens this CPD.xlsb file, Excel immediately shuts down. When we restart it, Excel wants to start in Safe Mode, which we do. And, after a normal shutdown/restart, Excel opens fine. But, the CPD.xlsb will cause Excel to close every time we try to open it.
There are no pop-ups or warnings or explanations of what happened. Excel just quits.
There isn't even time to Ctrl+Break to interrupt the code before Excel shuts down.
With almost 70 other users not having any problems, I can't imagine it's a programming issue.
I compared his Excel settings (File / Options) to mine, and they match exactly.
I have given him a brand new copy of CPD.xlsb and put it in a different folder, and it crashes.
I did the Quick Fix on MS Office 365 Pro Plus, and it still crashes.
I did the Online Repair for MS Office 365 Pro Plus, and it still crashes.
I sent him a different workbook with a simple Workbook_Open() routine that pops up a MsgBox, and it works fine.
Help! What am I missing? What would make this one PC shut down Excel the moment the file is opened?
Thanks for any suggestions! Russell