Excel keeps adding path to add in functions

[macintoshibe]

My computer runs on Windows 10, and I use Microsoft 365.

I made a calculation tool with an add in which performs water property calculations. For example to calculate the enthalpy of a saturated vapor at 10 degrees Celcius, type in a cell: enthalpySatVapTW(10+273)

In principle this works fine, however when I shut down and reopen the Excel file, Excel keeps adding a path in front of the addin functions. For example:
'someverylongpath'!enthalpySatVapTW(T_CE_in+273,15)

Till now I use find and replace to remove these paths, which works. However this is becoming unworkable as the Excel file grows in complexity... To make matters worse I have not found a way that all cells recalculate. Instead I have to click a cell, and make it recalculate again... How to prevent Excel from adding these paths?

Please help.

[romperstomper]

If the add-in is installed, that shouldn’t happen.

[MrShorty]

How to prevent Excel from adding these paths?

In my experience, you cannot. As rorya notes, when the add-in is correctly installed, Excel will hide the full path in the reference, but it is still there hidden in the function call. If this is happening everytime you shut down/restart Excel, that suggests to me that you have not correctly installed the add-in so that it loads automatically each time Excel starts. How are you installing the add-in?

[macintoshibe]

Just to answer my own question. I may have found a fix...

One way I found works is to:
- Click File
- Click Options
- Click Add-ins
- In the Add-ins manager look at the location where it searches for the add-in.
- Go to this folder and rename the water97_v13.xla to something else. Now it cannot find this file anymore and it will use an other copy which it stores in: C:\Users\Me\AppData\Roaming\Microsoft\Addins\water_97_v13.xla
- Now the problems should be fixed