XLPack 6.1 User’s Guide

1. System requirements

  • Windows 10 (Version 2004 or later) or Windows 11
  • Excel in Office 365, 2021, 2019, 2016 or 2013 (except Store version Excel)

2. List of functions/subroutines

The following functions/subroutines are provided.

List of functions/subroutines

The orange parts are the basic functions. 27 worksheet functions and 138 VBA functions/subroutines are provided for free.

M1 to M4 are additional features. Including these features, total of 148 worksheet functions and 902 VBA functions/subroutines will be available. The addon licenses are required by in-app purchase to use these additional features.

3. Installing software (Basic functions)

The software (basic functions) can be installed from Microsoft Store as “XLPack Basic”.

Refer to Download page.

4. Installing software (Additional functions)

In addition to “XLPack Basic”, install “XLPack Addons” from Microsoft Store.

Refer to Download page.

This app can be installed for free but it is not necessary if you are using only basic functions.
You can purchase additional functions (called as “addons” in Microsoft Store) by in-app purchase. See more details below.

Purchasing Addon details
Click “XLPack Addons” on Windows menu to start XLPack Addon Manager. It consists of the following three menus.

  • Activate license: To set up program to activate your licences.
  • Purchase license (Microsoft Store): To purchase licenses in Microsoft Store. Purchased licenses are not automatically activated. You need to activate them in “Activate license” menu.
  • Help: Links to some useful information.

Select “Purchase license (Microsoft Store)”.

Click “Purchase” button for what you want to purchase. Price for one year license is $14.99 for Modules 1 or 2, $11.99 for Modules 3 or 4, and $41.99 for a set of all Modules 1 to 4.

On completion of purchase procedure in Microsoft Store, the status is changed to “License purchased (Exp. date …) as below.”

Return to “Activate license” menu to activate purchased licenses. Click “Set up” button to set up program to activate licenses. This will take some time.

On completion the purchased licenses are ready for use.

Close XLPack Addon Manager.

The purchased license is linked to your Microsoft account and can be used on up to 10 devices per one account.

If you update XLPack Addons, you need to start XLPack Addon Manager and set up again. Otherwise, “Addon has been updated” error may occur when XLPack is used. If store app auto update is enabled, this error may occur unawarely. See more details in FAQ “Error: Addon has been updated”.

5. Setting up Excel

After installation of the software, you need to set up the Excel.

Enabling add-ins

  • Select Developer tab, and click Excel Add-Ins (Office 365 Excel, Excel 2019 or Excel 2016) or Add-Ins (Excel 2013).
  • To use XLPack worksheet functions, check “XLPack Worksheet Functions” in the “Add-ins available” list, and click “OK”.
  • To use XLPack solver, check “XLPack Solver” in the “Add-ins available” list, and click “OK”.
  • To use XLPack functions/subroutines in the VBA programs, check “XLPack VBA Library” in the “Add-ins available” list, and click “OK”.

Once you enabled the add-ins, they will be always effective regardless of the Excel file.

Note – If you cannot find the Developer tab, select File tab -> Options -> Customize Ribbon and check Developer.

Add-in setting example

References setting for using VBA subroutines/functions

  • Open Excel file and run Visual Basic editor by clicking Visual Basic button in Developer tab.
  • Select Tools -> References, and check “XLPack” in “Available Reference” list.

References setting is effective only within the Excel file used here.

If “XLPack VBA Library” add-in is not checked in the above mentioned procedure, “XLPack” may not appear in “Available Reference” list. In that case, select Tools -> References and click Browse and add C:\Users\User_Name\AppData\Roaming\Microsoft\AddIns\XLPack.xlam to the references.

Note – To use VBA library, references setting is necessary for each Excel file. Since the references are saved in the Excel file, it is not necessary to set up again when you open the Excel file next time. However, if the Excel file is used on the other PC with different user name, you may need to set the references again.

Reference setting example

6. Uninstalling software

To uninstall the software, use “Windows Settings” -> “Apps”. You must uninstall both “XLPack Basic” and “XLPack Addons”. Choose “XLPack Basic” or “XLPack Addons” and click “Uninstall”. Then choose another one and click “Uninstall”.

7. Sample worksheet

Sample worksheets using basic and additional functions can be downloaded from the following page.

Download page

8. Known issue

XLPack function names starting with W are worksheet functions, and others are VBA functions. Therefore, functions that do not start with W cannot be called from within worksheets.

Please refer to the following FAQ.

FAQ “A worksheet function does not work”