Forum Discussion
Excel Add-in disconnecting
MierMoto That is not how it is supposed to work (but you already know that).
A gap in the OPEN sequence in the registry would have explained this behavior, but apparently something else is amiss here.
All I can think of now is to suggest you to do an online repair of your Office. But I'm afraid that does not warrant a solution.
If you're brave (you'll loose your customizations and installed add-ins will be removed), you could:- Close all instances of Excel (check in Taks manager, details tab, kill any trailing Excel.exe there)
- open regedit and export Excel's entry in the registry:
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel - Delete that key
Now open Excel and install your add-in. Double-check if on reopening Excel the add-in loads. Then open your workbook which uses the UDFs.
I refresh the link by opening the add-in manager again (where I can see it's in the list and ticked) and then I browse for the file (it immediately opens in the correct location, where I can see the file), I double click it and then it warms me that it's already there, to which I ignore it and overwrite it. Then the dialog closes and the cells immediately updates and shows the correct values.
MierMoto That is not how it is supposed to work (but you already know that).
A gap in the OPEN sequence in the registry would have explained this behavior, but apparently something else is amiss here.
All I can think of now is to suggest you to do an online repair of your Office. But I'm afraid that does not warrant a solution.
If you're brave (you'll loose your customizations and installed add-ins will be removed), you could:
- Close all instances of Excel (check in Taks manager, details tab, kill any trailing Excel.exe there)
- open regedit and export Excel's entry in the registry:
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel - Delete that key
Now open Excel and install your add-in. Double-check if on reopening Excel the add-in loads. Then open your workbook which uses the UDFs.
- JKPieterse excellent, thanks for the extra tip. Fortunately I didn't get that annoying issue! Good to know though. These add-in issues seem to be quite persistent.
MierMoto As a side note, I wrote this article today: https://jkp-ads.com/Articles/excel-addin-remove-problem.asp
JKPieterse it was the registry edit.
MierMoto Which one helped please? The registry or the online repair?
JKPieterse that seems to have done the trick! Unfortunate that it had to go to that level, but it worked nonetheless.
Thank you so much for sticking in there and helping me through to a solution! I really appreciate that.