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.
MierMoto There is probably a problem in your Excel entry in the registry.
Open the registry editor and navigate to this location:
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options
In that key, most of Excel's settings are listed. Find the ones that begin with the word "OPEN" (without quotes):
look closely, these MUST be in order: OPEN, OPEN1, OPEN2, OPEN3, .....
If there is a gap, make sure you close that gap by renaming them. Make sure you close Excel first.
After renaming them, you should be able to add the add-in as usual.
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.
- If the add-in is checked in the list of add-ins and the add-in loads when Excel is opened, this normally works without a hitch.
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?