You can avoid it by manually giving the permission for ordinary access to the xlam file as follows: One possible cause of this problem is the security feature of Windows. and select the location of your xlam file. If you are having problems with the path to the XLAM in your worksheet appearing as the complete path to the xlam (but not the correct path), you might need to go into Data->Update Links in Excel, select CoolProp.xlam, and select Change Source. Open the Visual Basic editor and use Edit | Replace to replace all occurrences of CoolProp_stdcall.dll with the full path to the alternate location for your DLL files, making sure to press the save button (disk image) or File | Save before exiting the VBA editor.Make sure that the Developer main tab is checked (ON).Go to File | Options on the main menu and select Cusomize Ribbon.Make sure that the Developer ribbon is visible on the main menu.Press and hold the ``Enter`` key until all of the errors clear. Clicking Ok on the error will only clear the first of many.

You will get an Excel error, File not found - CoolProp_stdcall.dll.

Place the CoolProp xlam file in a writable location and open it.

Place the CoolProp DLL files in the alternate location.If this is the case, you will need to put the DLL files in an alternate location (possibly on a shared network location for all users). (To recalculate the entire worksheet, press Ctrl- Alt- Shift- F9 ) Īlternate DLL Location - Some environments, lock down the folders included in the binary search path for normal users for security reasons. Open the file TestExcel.xlsx and try to re-evaluate one of the cells the CoolProp formulas should all be working now.Make sure the CoolProp Add-in is selected (box checked) and close the Add-in Manager.Browse to the file CoolProp.xlam you downloaded and select it.Click the Browse button on the Add-in Manager panel.At the bottom, select Manage: Excel Add-ins, then click the Go.The TestExcel.xlsx from MicrosoftExcel can be copied to a working directory in My Documents.and copy the files to a convenient accessible location. Download the xla and xlam files from MicrosoftExcel and activate the add-in from Excel as described below.The Excel macro will select the correct one and use it. Technically you only need the DLL that matches your system architecture ( CoolProp_stdcall.dll = 32-bit, CoolProp_圆4.dll = 64-bit), but it can’t hurt to copy both if you don’t know which system architecture version you have. Make sure to add that folder to your path. Get the shared libraries at shared_library/Windows/32bit_stdcall and shared_library/Windows/64bit, put the DLLs into a folder of your choice and rename them to CoolProp_stdcall.dll and CoolProp_圆4.dll.

Running coolprop with excel for mac