If you have a folder full of blocked files, After renaming them, you should be able to add the add-in as usual. Sure you close that gap by renaming them. MUST be numbered in order: OPEN, OPEN 1, OPEN 2, OPEN 3, Find the ones thatīegin with the word "OPEN" (without quotes). In that key, most of Excel's settings are listed. Open the registry editor and navigate to this location: Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options This is probably due to a bug in Excel which causes the add-in entries The add-in is no longer installed (and hence does not open). Some users report that even though they can check an add-in in the add-insĭialog and that add-in then works, as soon as they close and reopen Excel, Right-click the file and choose properties:
Copy the file from the zip file to any folderĢ. Even if thoseįiles were in a zip container, they are marked as blocked. Internet (so this includes add-ins) to be marked as Blocked.
The causeĪ recent Office Security update has caused any file downloaded from the
In fact, the add-in file will not open inĮxcel at all, even if you try from Windows Explorer, or from File, Openįrom within Excel. button):Īs you can see, some add-ins are checked. This is that dialog (you get thereīy going to File, Options, Add-ins tab and pressing the Go. The problemĮven though an add-in has been "installed" into Excel using the Add-insĭialog its userinterface does not show. With which you can do search and replace in all of Excel'sįrom people complaining that they can no longer use add-ins.
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.
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.