Excel Installation Problems

[John French]

System: Windows 11 fully updated & Office 365 (rebuilt as a precaution).

Neither the installer method (CoolProp_v6.8.0.0.exe) nor the components method (CoolProp.dll, CoolProp_x64.dll, CoolProp.xlam) is working for me.

The add-in is present and the add-in folder is inserted into "trusted location". 

VBA macros are enabled.

Here's the installer link >>

https://sourceforge.net/projects/coolprop/files/CoolProp/6.8.0/Installers/Windows/CoolProp_v6.8.0.0.exe/download

The instructions >>

https://www.youtube.com/watch?v=I4nugwRtcZU&pp=ygUII25zaXRleGU%3D&t=5

I have also tried an older version 6.4.1.0 (used in above instructions) with the same results.

Times have changed ... I graduated in 88 and have enjoyed using SRK in ASPEN and ChemCad in the 90's. Sure would appreciate advice on what I might be doing wrong.

[Ian Bell]

Please indicate what problems you are seeing

--
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 visit https://groups.google.com/d/msgid/coolprop-users/903489ff-ba75-44e5-8c84-af3106d08672n%40googlegroups.com.

[John French]

Addendum --  The problems observed are failure to populate the spreadsheet in the 3'rd column "COOLPROP". What is in each cell is "#NAME?"

Possibly a connectivity issue that might be related to changes in Windows 11 vs Windows 10?

Possibly a variables naming/handling problem again related to Windows 11?

When I used CMAKE to build the linkage with Visual Studio Community 2022 C++ ... there were a few error handling issues upon compilation that I was able to comment out and proceed successfully ... but that is a separate issue and one I would have to repeat and document to be of value. The Excel failure has no diagnostics that might be useful at my CoolProp novice and end-user only status.

[Ian Bell]

Excel is always tricky with these things because you get almost no useful debugging information. What precise version of Excel do you have? A screenshot of the "About" would be good.

--

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 visit https://groups.google.com/d/msgid/coolprop-users/8fe38ab4-08a4-4944-ac4a-83835304e078n%40googlegroups.com.

[John French]

The following is from >>  About Excel

Microsoft® Excel® for Microsoft 365 MSO (Version 2505 Build 16.0.18827.20102) 64-bit 

I am using "Current Channel" version ... not a Beta user (Microsoft Insider) ... however I did watch this video >> Bing Videos

and at 2:24 is some discussion how new "beta" versions can cause incompatible results and shows the exact value in cells as I am experiencing >>  #NAME?

... thus it is very likely that the Excel 365 "Current Channel" has some updates that are incompatible with the CoolProp Excel Wrapper. OUCH !!

Chasing down that issue is way beyond my skillset. OUCH^2 !!

[Ian Bell]

I have no idea, and don't use Excel. Maybe someone else does. It is a nightmare to debug this particular issue and I don't have bandwidth for it.

To view this discussion visit https://groups.google.com/d/msgid/coolprop-users/16f46ee4-8473-48a2-a0d8-be95ccfe5ec8n%40googlegroups.com.

[Murilo Monteiro]

Hello John,

I just want to tell you that my Coolprop - excel installation is working fine ( win10 and Mac):

=@get_global_param_string("version”)

6.5.0

 
Win 10 Microsoft® Excel® para Microsoft 365 MSO (Versão 2507 Build 16.0.18928.20002) 64 bits 
Canal Beta

Microsoft® Excel para Mac Versão 16.89.1 (24091630)

I followed those instructions for windows and Mac :

https://coolprop.org/coolprop/wrappers/Excel/index.html

Regards, 

Murilo

To view this discussion visit https://groups.google.com/d/msgid/coolprop-users/CAJQnXJc9H3VjORAYjMpa_oypfZA8Q4TJ2xUq7Sg33GDZxQ8qtQ%40mail.gmail.com.

[John French]

Thanks for the tips/support with the Excel challenge. CoolProp is spectacular as is its interconnectivity. 

It's unreasonable to expect developers to test on every update of Excel as they occur ... but eventually I'd bet it gets sorted out.

Fortunately, for spot checking a C++ library call (plus primary calcs outside a structured programming language), there is also engineeringpapers.xyz that appears *very* friendly with units conversions. >>  https://www.youtube.com/@epxyz

My long term project involves compressor analysis and CoolProp *greatly* eases the calculational cumbersomeness.

interesting that viscosity output parameters are a bit nuisance >> V for PropsSI() .. and .. M for HumidAir::HAPropsSI()

I'd have recommended "mu" throughout.

Some of the AI generated examples are VERY helpful ... and sometimes just a little glitchy. So to give back a little ...

Here's my "Hello CoolProp" main() and its output >>

#include "CoolProp.h"
#include "CoolPropLib.h"
#include "HumidAirProp.h"

#include <iostream>
#include <cstdio>


int main() {
 printf("Hello Newbie To CoolProp\n");
 // Example 1: Calculate density of water at 300 K and 101325 Pa
 double density = CoolProp::PropsSI("D", "T", 300, "P", 101325, "Water");
 printf("\n%s[%d]: Density of Water: %+24.18e kg/m^3\n", __func__, __LINE__, density);

 // Example 2: Calculate enthalpy of R134a at 273.15 K and quality 0 (saturated liquid)
 double enthalpy = CoolProp::PropsSI("H", "T", 300.0, "Q", 0, "R134a");
 printf("\n%s[%d]: Enthalpy of R134a: %+24.18e J/kg\n", __func__, __LINE__, enthalpy);

 double T = 298.15;    // Temperature in Kelvin (25°C)
 double P = 101325;    // Pressure in Pascals (1 atm)
 double R = 0.5;       // Relative humidity (50%)

 printf("\n%s[%3d]: The following calcs use >>  T = 298.15 K, P = 101325 Pa\n", __func__, __LINE__);

 double h_pure_air = CoolProp::PropsSI("H", "T", T, "P", P, "air");
 printf("\n%s[%d]: Enthalpy          ---  h_pure_air: %+24.18e J/kg\n", __func__, __LINE__, h_pure_air);

 double D_pure_air = CoolProp::PropsSI("D", "T", T, "P", P, "air");
 printf("\n%s[%d]: D_pure_air: %+24.18e kg/m^3      Volume_pure_air: %+24.18e m^3/kg\n", __func__, __LINE__, D_pure_air, 1 / D_pure_air);

 double viscosity_pure_air = PropsSI("V", "T", T, "P", P, "air");
 printf("\n%s[%d]: Dynamic viscosity_pure_air: %+24.18e Pa*s   (Compare to zero relative  humidity  below.)\n", __func__, __LINE__, viscosity_pure_air);

 printf("\n######################################################################\n");

 printf("\n\n%s[%d]: Psychometric Calcs Using >>  HumidAir::HAPropsSI()  --- Relative Humidity = 0.5\n", __func__, __LINE__);
 double h_da = HumidAir::HAPropsSI("Hda", "T", T, "P", P, "R", R);
 printf("\n%s[%d]: Enthalpy Dry Air Basis  ---  h_da: %+24.18e J/kg dry air\n", __func__, __LINE__, h_da);

 double h_ha = HumidAir::HAPropsSI("Hha", "T", T, "P", P, "R", R);
 printf("\n%s[%d]: Enthalpy Humid Air      ---  h_ha: %+24.18e J/kg humid air\n", __func__, __LINE__, h_ha);

 double V_da = HumidAir::HAPropsSI("Vda", "T", T, "P", P, "R", R);
 printf("\n%s[%d]: Volume Dry Air Basis    ---  V_da: %+24.18e m^3/kg dry air\n", __func__, __LINE__, V_da);

 double V_ha = HumidAir::HAPropsSI("Vha", "T", T, "P", P, "R", R);
 printf("\n%s[%d]: Volume Humid Air        ---  V_ha: %+24.18e m^3/kg wet air\n", __func__, __LINE__, V_ha);

 double Molar_fraction_H2O_air_humid = HumidAir::HAPropsSI("Y", "T", T, "P", P, "R", R);
 printf("\n%s[%d]: Molar_fraction_H2O_air_humid: %+24.18e\n", __func__, __LINE__, Molar_fraction_H2O_air_humid);

 double viscosity_air_humid = HumidAir::HAPropsSI("M", "T", T, "P", P, "R", 0.0);
 printf("\n%s[%d]: Dynamic viscosity_air_humid: %+24.18e Pa*s at Relative humidity = 0.0\n", __func__, __LINE__, viscosity_air_humid);

 viscosity_air_humid = HumidAir::HAPropsSI("M", "T", T, "P", P, "R", R);
 printf("\n%s[%d]: Dynamic viscosity_air_humid: %+24.18e Pa*s at Relative humidity = 0.50\n", __func__, __LINE__, viscosity_air_humid);

 viscosity_air_humid = HumidAir::HAPropsSI("M", "T", T, "P", P, "R", 1.0);
 printf("\n%s[%d]: Dynamic viscosity_air_humid: %+24.18e Pa*s at Relative humidity = 1.0\n", __func__, __LINE__, viscosity_air_humid);

 printf("\n%s(%d):  program paused ...", __func__, __LINE__);  system("pause");
 return 0;
}

Output >>

Hello Newbie To CoolProp

main[13]: Density of Water: +9.965569352652021280e+02 kg/m^3

main[17]: Enthalpy of R134a: +2.371891840113258222e+05 J/kg

main[ 23]: The following calcs use >>  T = 298.15 K, P = 101325 Pa

main[26]: Enthalpy          ---  h_pure_air: +4.244360439165021526e+05 J/kg

main[29]: D_pure_air: +1.184318483908966435e+00 kg/m^3      Volume_pure_air: +8.443674683683023430e-01 m^3/kg

main[32]: Dynamic viscosity_pure_air: +1.844808216200202516e-05 Pa*s   (Compare to zero relative humidity below.)

######################################################################


main[36]: Psychometric Calcs Using >>  HumidAir::HAPropsSI()  --- Relative Humidity = 0.5

main[38]: Enthalpy Dry Air Basis  ---  h_da: +5.042345039075703971e+04 J/kg dry air

main[41]: Enthalpy Humid Air      ---  h_ha: +4.992787927743897308e+04 J/kg humid air

main[44]: Volume Dry Air Basis    ---  V_da: +8.577882434265996503e-01 m^3/kg dry air

main[47]: Volume Humid Air        ---  V_ha: +8.493577399308691600e-01 m^3/kg wet air

main[50]: Molar_fraction_H2O_air_humid: +1.570849649916924995e-02

main[53]: Dynamic viscosity_air_humid: +1.844808216200202516e-05 Pa*s at Relative humidity = 0.0

main[56]: Dynamic viscosity_air_humid: +1.835900052184231623e-05 Pa*s at Relative humidity = 0.50

main[59]: Dynamic viscosity_air_humid: +1.826965930958964786e-05 Pa*s at Relative humidity = 1.0

main(61):  program paused ...Press any key to continue . . .

[Tilek Aberra]

=@get_global_param_string("version”)

6.1.0

On Wed, 18 Jun 2025 at 9:04 am, Tilek Aberra <tilek....@gmail.com> wrote:

I also have no issue of using coolprop in excel both before and after windows-11 upgrade.

To view this discussion visit https://groups.google.com/d/msgid/coolprop-users/9AA9753A-65A8-4FAE-A704-B23E31B24B09%40gmail.com.

[Tilek Aberra]

I also have no issue of using coolprop in excel both before and after windows-11 upgrade.

On Wed, 18 Jun 2025 at 8:50 am, Murilo Monteiro <murilomo...@gmail.com> wrote:

To view this discussion visit https://groups.google.com/d/msgid/coolprop-users/9AA9753A-65A8-4FAE-A704-B23E31B24B09%40gmail.com.

[Fausto A. A. Barbuto]

I use Coolprop in Excel Professional Plus 2019 and Windows 11. But I had some

hard time (as far as I remember) to get it working properly. Those things are a

bit tricky sometimes. 

Fausto

To view this discussion visit https://groups.google.com/d/msgid/coolprop-users/CAL2pGC6ac5HQP6Lda2mFY6HFTkHNfZHf%3Dnu7-8oJfx7UDatCJw%40mail.gmail.com.

[Jeff Henning]

In our corporate environment under Windows 11 and Office 365, our corporate IT department has turned on the option that requires all add-ins to be code signed.

This requires users to get a code-signing certificate and sign the add-in XLA,XLAM as trusted.  The add-in certificate must be updated periodically.  I do this in our corporate environment.  If your corporate environment requires code-signing and you can't turn it off, this may be the source of your issues.  Your corporate IT department should provide you with a way to obtain a code-signing certificate so you can code-sign the add-in.

At home, I simply have this requirement turned off.

Jeff