Installing XLPack Lite 5.2 (macOS version)
1. System requirements
- macOS Mojave (10.14.5 or later)
- Excel for Mac (Office 365 (Subscription) or Office 2019 for Mac (One-time purchase)) (16.26 (19060901) or later)
The older versions cannot be used. Please use the latest versions of macOS and Excel for Mac as indicated above. XLPack does not work with Office 2016 for Mac (One-time purchase).
**Note** There are several known issues on XLPack solver and worksheet functions at this moment. Please refer to section 8 below.
2. Downloading software
Download software from here.
Note – At this moment, only the beta version is available.
3. Installing software
Double click to open distributed dmg file. Then double click the installer program (XLPackLite-5.2.1.x.pkg) in the distributed dmg file and continue installation by following the messages of install program. The admin password will be required.
4. Setting up your Excel
After installation of the software, you need to set up the Excel.
Enabling add-in for using worksheet functions
Select Developer tab, and click Excel Add-Ins.
Note – If you cannot find the Developer tab, select Excel -> Preferences -> Ribbon & Toolbar and check Developer in Main Tabs.
In the “Add-ins available” list, check “XLPack Lite Worksheet Functions” and click “OK” so that the add-in for worksheet functions is enabled. If you cannot find “XLPack Lite Worksheet Functions” in the “Add-ins available” list, click Browse and select XLPackLiteWS.xlam in Macintosh HD:Library:Application Support:Microsoft:Office365:User Content:Add-Ins and click Open so that the add-in for worksheet functions is enabled.
In the “Add-ins available” list, check “XLPack Lite Solver” and click “OK” so that the XLPack Lite solver add-in is enabled. If you cannot find “XLPack Lite Solver” in the “Add-ins available” list, click Browse and select XLPackLiteWS.xlam in Macintosh HD:Library:Application Support:Microsoft:Office365:User Content:Add-Ins and click Open so that the XLPack Lite solver add-in is enabled.
Once you have enabled the add-in, it will be always effective regardless of the Excel files.
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 click Browse and add Macintosh HD:Library:Application Support:Microsoft:Office365:User Content:Add-Ins:XLPackLite.xlam to the references. References setup is effective only within the Excel file used here.
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.
5. Uninstalling software
Double click to open distributed dmg file. Then double click the uninstall script (Uninstall) in the distributed dmg file and continue uninstallation by following the messages of script. The admin password will be required.
Instead, if you want to uninstall manually, delete the following five files.
XLPackLite.dylib, XError1Lite.dylib, XLPackLite.xlam, XLPackLiteWS.xlam and XLPackLiteSolver.xlam
in the directory /Library/Application Support/Microsoft/Office365/User Content.localized/Add-Ins.localized/
Then delete the package information.
sudo pkgutil –forget biz.ktech.pkg.XLPackLite
- Subroutine and function manuals
Please refer to here.
- XLPack solver manual
Please refer to here.
Please refer to here.
7. Sample worksheet
In addition to manuals, sample worksheets are provided to support users’ quick start of using XLPack. Examples of most subroutines and functions are included.
Download from here.
8. Known issues
There are several known issues at this moment as described below. Please refer to FAQ site for details.
(1) Worksheet functions
- Help information (such as description of arguments) of XLPack worksheet functions is not shown in the Formula Builder (which is displayed by fx button).
(2) XLPack solver
- RefEdit control which is used to select a range of cells in dialog does not work correctly when trying to select multiple cells. As a workaround, click square button at the right of box (minimize button) first so that the dialog box is minimized. Then you can select a range of cells correctly.
- A part of form (grouped part) sometimes displayed white.
- When solver write the data such as calculation results to cells, the display is sometimes not updated and it seems like the calculation was not done. When dialog is closed, the display is updated.