Excel keeps adding path to add in functions

[macintoshiba]

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: @'C:\Users\arnes\AppData\Roaming\Microsoft\AddIns\water97_v13.xla'!enthalpySatVapTW(10+273)

Till now I use find and replace to remove these paths, but 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.

[#2]

@macintoshiba

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