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.
JKPieterse thanks for the quick reply.
Unfortunately it doesn't seem to the solution, unless I'm checking the wrong folders. I have three OPTION entries and they're in the correct order (see below). I also followed the path you indicated:
I'm not sure that I'm just interpreting your last comment incorrectly, but I don't have an issue opening the add-in, it's just that when I use the custom function from the add-in in a cell, save and close the file and then later open it, it seems to have lost the connection to that function and reverts back to a 0 result and instead of only showing the function name, it also has the path to where the function is stored, but it's not using it. I then have to going and re-point the add-in to the XLAM file and only then does it pick up the function.
By the way, I also updated my post to say that I'm running Office 365, 64bit on Windows 10.
Here are two articles I wrote about add-ins which may or may not apply?
https://jkp-ads.com/Articles/Excel-Add-ins-fail-to-load.asp
https://jkp-ads.com/Articles/FixLinks2UDF.asp
- Thanks again for the reply.
I tired the security setting before, but I actually didn't have that option to unblock the file. The area at the bottom of my properties dialog is empty.
The function I'm using is a UDF, but it works just fine when I enter it the first time. It'll be:
=BFCVolSimple("EP",R16088,S16088,5)
...but then when I open it later, the cell value will be 0 and the formula will be:
='C:\Users\User\AppData\Roaming\Microsoft\AddIns\BFC Volume Functions EP.xlam'!BFCVolSimple("EP",R16088,S16088,5)
I also didn't change the file path. It's using the default "C:\Users\User\AppData\Roaming\Microsoft\AddIns\BFC Volume Functions EP.xlam" path.- Fair enough. Sorry if I'm repeating my question, but:
1. Is that add-in checked in your list of add-ins
2. Is the add-in actually loaded (check in the VBA Editor in the project explorer, see whether it is there)
You say the add-in is protected; can you contact its developer by any chance?JKPieterse No problem! I really appreciate the help.
- It's definitely checked. In fact, when I reopen the file and I try to refresh the link to the UDF, I get prompted that the file already exists and whether I want to overwrite it. I keep it switched on. Simply opening the add-in dialog and checking whether it's switched on, doesn't help. I need to actually browse for it again (although it hasn't moved) and select it again. Only then does the formula update and the values revert to what they need to be.
- It's loaded when I use it at first. Then when I come back the file later, it's not in the VBA Editor anymore. When I then repoint it to the UDF, it pops back in the VBA Editor.