I have an Excel spreadsheet that contains a reference to a DLL whose
interface has changed. When I go to references I see the message
"SciDirRoutines.dll Missing". So, I try to uncheck the reference so I
can reference the new DLL. However, after unclicking the check box,
then hitting OK, I get an "error loading DLL" message.

So, I am prevented from removing a reference to a non-existant DLL.

How can I escape this catch 22?

TIA