Setting up add-ins manually for XLPack 5.2 (Windows version)

To use worksheet functions and/or solver, you need to set up the Excel to enable the add-ins.

Usually the add-ins for worksheet functions and solver can be enabled by: Select Developer tab, and click Excel Add-Ins (Office 365 Excel, Excel 2019 or 2016) or Add-Ins (Excel 2013 or 2010). In the “Add-ins available” list, check “XLPack Worksheet Functions” (“XLPack Lite Worksheet Functions” for Lite version) and “XLPack Solver” (for modules 3 and 4, and Lite version), and click “OK”.

However, if the installer program could not identify the Excel installation on your PC during the install process, “XLPack Worksheet Functions” (“XLPack Lite Worksheet Functions” for Lite version) and “XLPack Solver” (for modules 3 and 4, and Lite version) will not appear in the “Add-ins available” list. In that case, you need to set add-in file manually.

The manual setup procedure is described below.

Identifying whether the Excel(Office) is 32 bit or 64 bit version

When you are using 32 bit Windows, Excel should be 32 bit version.

When you are using 64 bit Windows, Excel may be 64 bit or 32 bit version. You need to identify as follows.

  • Open blank worksheet with Excel
  • Select File tab
  • Click Account (Office 365 Excel, Excel 2019, 2016 or 2013) or Help (Excel 2010)
  • Click About Excel so that the bit version (32-bit or 64-bit) will be displayed (Office 365 Excel, Excel 2019, 2016 or 2013), or you can find bit version under About Microsoft Excel (Excel 2010)

Setting up add-ins

The appropriate add-in files to be set up are as follows.

Windows bit version Excel bit version Add-in files
32 bit 32 bit C:\Program Files\KTech\XLPack\XLPack_32.xll
C:\Program Files\KTech\XLPack\XLPackLite_32.xll (Lite version)
C:\Program Files\KTech\XLPack\XLPackSolver_32.xll (modules 3 and 4, Lite version)
64 bit 32 bit C:\Program Files (x86)\KTech\XLPack\XLPack_32.xll
C:\Program Files (x86)\KTech\XLPack\XLPackLite_32.xll (Lite version)
C:\Program Files (x86)\KTech\XLPack\XLPackSolver_32.xll (modules 3 and 4, Lite version)
64 bit 64 bit C:\Program Files (x86)\KTech\XLPack\XLPack.xll
C:\Program Files (x86)\KTech\XLPack\XLPackLite.xll (Lite version)
C:\Program Files (x86)\KTech\XLPack\XLPackSolver.xll (modules 3 and 4, Lite version)

You can set up the add-ins as follows.

  • Select Developer tab, and click Excel Add-Ins (Office 365 Excel, Excel 2019 or 2016) or Add-Ins (Excel 2013 or 2010).
  • Click Browse.
  • Specify the appropriate add-in files and click OK.
  • Confirm the checked “XLPack Worksheet Functions” (“XLPack Lite Worksheet Functions” for Lite version) and “XLPack Solver” (for modules 3 and 4, and Lite version) appear in the Add-ins available list, then click OK.
Top