Closing Excel clicking on the x in the upper right corner and then cancel it.

[ShieldTrade]

Hi @cunnane, I regret I am not able to propose a solution. I am not skilled enough. I am a monkey debugger, sorry about it

Xloil version 0.17.14
Python modules is loaded on start up using LoadModules in the config TOML file.

Step to reproduce the issue:
Close excel clicking on the X in the upper right corner.
Click cancel or the X on the msg box.

Issue:
All Xloil functions return #VALUE
Full recalculate does not change anything.
If I click on the cell and then I press enter all Xloil functions return #NAME?

[cunnane]

This may not be possible to work around - by the time you click 'Cancel', Excel has already unloaded all addins, hence all the functions registered by the addins have been de-registered. I'll have a little dig into possibilities....

[keithalewis]

@ShieldTrade This is a known "feature" of Excel. If you close a workbook then click Cancel all the add-ins will be unregistered.
The solution is "Don't do that." :-)

[ShieldTrade]

I also noticed that if you try to close excel while xloil is loading excel will crash