XLPack 7.0 User’s Guide
1. System requirements
- Windows 10 (Version 22H2) or Windows 11
- Excel in Office 365, 2024, 2021, 2019 or 2016 (except Store version Excel)
2. List of functions/subroutines
The following functions/subroutines are provided.
The orange parts are the basic functions. 27 worksheet functions and 175 VBA functions/subroutines are provided for free.
M1 to M5 are additional features. Including these features, total of 216 worksheet functions and 1218 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 XLPack software (basic functions) can be downloaded from this site or installed from Microsoft Store.
Refer to Download page.
4. Installing software (Add-ons)
If XLPack (basic function) is already installed, you can expand the functionality by installing the app “XLPack Addons” from Microsoft Store. This app can be installed for free, but it is not required if you are only using the basic functions.
Refer to Download page.
You can purchase licenses for additional features (add-ons) by in-app purchase and set them up. See below for details.
- Install license(s): Set up the program to use the purchased licenses.
- Purchase license(s) (Microsoft Store): Purchase license(s) at the Microsoft Store. The License(s) purchased here will not be used automatically. You must return to the “Install license(s)” menu to set up the program.
- Help: Links to manuals, etc.
Select “Purchase license(s) (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, 4 or 5, and $41.99 for a set of all modules 1 to 5 (*).
You will need a Microsoft account to complete the purchase process. You will need to register your payment method on Microsoft website under “Payment and billing information” and “Payment options.”
(*) If you already have a license for modules 1 to 4 of the previous version (6.0 or 6.1), you can use it as a license for modules 1 to 5 of the current version.
On completion of purchase procedure in Microsoft Store, the status is changed to “License purchased (Exp. date …) as below.”
Return to “Install license(s)” menu to use purchased licenses. Click “Setup” button to set up program to use licenses.
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.
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.
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.
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.
