CoolProp in Excel

[Dawid]

Hi,

I have experienced problem while sharing Excel files, which use CoolProp.

For example, when my colleague (both of use have Excel add-in installed) open a file where I used CoolProp the formula:

=@PropsSI("Dmass","T",E9,"P",E10,E8)

changes to 

=@'C:\Users\dbi\AppData\Roaming\Microsoft\AddIns\CoolProp.xlam'!PropsSI("Dmass","T",E9,"P",E10,E8)

The problem is that 'dbi" is my username and the function is not forking for him correctly.

Have someone experienced similar problem with Excel?
If yes, how can it be solved?

Thanks 

Dawid

[Ian Bell]

I forget what it is called in Excel, I think "update references" or something like that. That should repair the references.

--
You received this message because you are subscribed to the Google Groups "coolprop-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to coolprop-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/coolprop-users/663591e2-1b07-4566-bc23-547a6560eb87n%40googlegroups.com.

[theangkko]

This is not related to CoolProp (xlam).
 
Excel Add-In(named as .xlam extension) is installed at " %USERPROFILE%\AppData\Roaming\Microsoft\AddIns " in window10/11. 

So if you use CoolProp function in excel sheet, you just need to use "=PropsSI("Dmass","T",E9, "P",E10,E8)". 

When the file including VBA macro(.xlsm) is transfered to other PC(person), MS OneDrive, Share Folders, 

your excel file store YOUR .xlam file location automatically.
 
To solve this,
Delete all "@'C:\Users\dbi\AppData\Roaming\Microsoft\AddIns\CoolProp.xlam'!" 

from @~ to !. using Ctrl + H_Excel replace function

2023년 1월 19일 목요일 오후 6시 9분 42초 UTC+9에 Dawid님이 작성: