search

CoolProp / CoolProp

Thermophysical properties for the masses
http://coolprop.org/
MIT License
771 stars 306 forks source link

CoolProp 6.5.0 installed on Win 10, but TestExcel.xlsx is not showing values. #2285

Closed Amardeepjyoti closed 9 months ago

Amardeepjyoti commented 1 year ago

I installed CoolProp_6.5.0 on Win 10 using the windows installer. Everything went smoothly, but I am not able to see any results in the TestExcel.xlsx file. Could I request for some solution on this or any alternate methods to try?

image

I am able to see the Add-ins in Excel and it points to the right XLAM file at location: AppData -> Roaming -> Microsoft -> AddIns Excel version is 2306 on Microsoft 365. image image

I also checked the formula method to see if I am able to add formula into a new cell. image

I cannot see where the installation has happened, so I cannot say where the .dll files are.

System specs: Win 10, 64bit Excel spec: Microsoft 365, v2306, 64bit.

jowr commented 1 year ago

It might be the bitness - did you install the 32bit DLLs instead of the 64bit ones?

Just to make sure, you could reinstall and select the 64bit installation.

henningjp commented 1 year ago

Hmmm... Maybe this? https://answers.microsoft.com/en-us/msoffice/forum/all/microsoft-365-excel-addin-stopped-working-after/872e6730-13c2-448c-80c3-ab6e83369735

Jurgens92 commented 9 months ago

Hi, Have you found a resolution? Im facing the exact same issue, on multiple computers. all of them are 64bit - office365

Amardeepjyoti commented 9 months ago

Hey @Jurgens92, yeah it is working for me. Unfortunately, I don't know what the issue was, but here are the steps that I follow off the top of my head. Step 1: I removed every trace of CoolProp from everywhere. Step 2: I tried the installation through the executable file. Step 3: Make sure the CoolProp path is added to the User variable of "Environment Variable". Possible path is "C:\Users\xxxxxxx\AppData\Roaming\CoolProp" for reference. Step 4: Open the Test excel if it shows the values. Step 5: If it does not show the values then check the addins in Excel and make sure the functions are visible such as PropsSI, etc. (check above for reference). Step 6: If the addin is successful and the values are still not visible on the test excel, then open a new excel file and try executing the following "=@PropsSI("D","T",297,"P",10^5,"Helium")" in a cell and you should get a value of 0.162010664.

I hope this helps. Abovementioned are the steps that I followed as far as I remembered.