Excel keeps adding path to add in functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2136770%22%20slang%3D%22en-US%22%3EExcel%20keeps%20adding%20path%20to%20add%20in%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2136770%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20computer%20runs%20on%20Windows%2010%2C%20and%20I%20use%20Microsoft%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20made%20a%20calculation%20tool%20with%20an%20add%20in%20which%20performs%20water%20property%20calculations.%20For%20example%20to%20calculate%20the%20enthalpy%20of%20a%20saturated%20vapor%20at%2010%20degrees%20Celcius%2C%20type%20in%20a%20cell%3A%20%3CSPAN%3EenthalpySatVapTW(10%2B273)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIn%20principle%20this%20works%20fine%2C%20however%20when%20I%20shut%20down%20and%20reopen%20the%20Excel%20file%2C%20Excel%20keeps%20adding%20a%20path%20in%20front%20of%20the%20addin%20functions%20for%20example%3A%26nbsp%3B%40'C%3A%5CUsers%5Carnes%5CAppData%5CRoaming%5CMicrosoft%5CAddIns%5Cwater97_v13.xla'!enthalpySatVapTW(10%2B273)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETill%20now%20I%20use%20find%20and%20replace%20to%20remove%20these%20paths%2C%20but%20this%20is%20becoming%20unworkable%20as%20the%20Excel%20file%20grows%20in%20complexity...%20To%20make%20matters%20worse%20I%20have%20not%20found%20a%20way%20that%20all%20cells%20recalculate.%20Instead%20I%20have%20to%20click%20a%20cell%2C%20and%20make%20it%20recalculate%20again...%20How%20to%20prevent%20Excel%20from%20adding%20these%20paths%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2136770%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2137223%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20keeps%20adding%20path%20to%20add%20in%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2137223%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F967278%22%20target%3D%22_blank%22%3E%40macintoshiba%3C%2FA%3E%3C%2FP%3E%3CP%3EJust%20to%20answer%20my%20own%20question.%20I%20may%20have%20found%20a%20fix...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20way%20I%20found%20works%20is%20to%3A%3CBR%20%2F%3E-%20Click%20File%3CBR%20%2F%3E-%20Click%20Options%3CBR%20%2F%3E-%20Click%20Add-ins%3CBR%20%2F%3E-%20In%20the%20Add-ins%20manager%20look%20at%20the%20location%20where%20it%20searches%20for%20the%20add-in.%3CBR%20%2F%3E-%20Go%20to%20this%20folder%20and%20rename%20the%20water97_v13.xla%20to%20something%20else.%20Now%20it%20cannot%20find%20this%20file%20anymore%20and%20it%20will%20use%20an%20other%20copy%20which%20it%20stores%20in%3A%20C%3A%5CUsers%5CMe%5CAppData%5CRoaming%5CMicrosoft%5CAddins%5Cwater_97_v13.xla%3CBR%20%2F%3E-%20Now%20the%20problems%20should%20be%20fixed%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

 

 

1 Reply

@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