From Table or Range Monkey
Article Overview One of the things we have been asking the Excel team to do for a long time is give us the ability to
Menu
While we hope that Monkey Tools installs easily and keeps running, the reality is that software is a complicated thing, and sometimes things break. This article is intended to capture the most common issues that can occur, and provide solutions to get you (back) up and running as quickly as possible.
This article is divided into three main sections
For the most part, installing Monkey Tools is easy, and can be accomplished following the steps in the Installing Monkey Tools support article. Having said this – for those who do run into issues – these are the most common we’ve experienced.
For a variety of reasons, Monkey Tools installs using a “Click Once” installer via the https://monkeytools/software/monkeytools.application link. Whether you download the installer or run it from the web, it will still contact https://monkeytools.ca for the installation files as well as future updates. If your organization blocks Click Once installers or the ability to install software from the internet, it will most likely block the installation of Monkey Tools.
In the entire time we have been distributing Monkey Tools, we have only ever received one support call related to this issue. The Anti-Virus software in question was PC Matic, and was blocking our installer from running. Once the anti-virus was temporarily disabled, it allowed the Monkey Tools installation to proceed as expected.
Monkey Tools is signed by a “Sectigo RSA Code Signing CA” certificate, which should be trusted by most organizations. We have encountered one government agency who does not trust this issuer however, which blocks the installation of Monkey Tools completely. Unfortunately, there is no way for us to resolve this issue, as the IT department needs to whitelist our digital certificate provider.
In most cases, activating your Monkey Tools license can be done by following the steps listed in our Activating Your License article. If you run into an error, however, please read the section below for known issues/resolutions.
Monkey Tools licensing is managed via Soraco‘s licensing service, which makes a call to the https://qlm2.net domain. If you are experiencing issues with activating your license, we suggest that you whitelist this domain in your firewall software. If that still doesn’t solve the issue, please reach out to us.
We consider a successful installation one where you were able to install Monkey Tools and see the Monkey Tools tab in your Excel ribbon as shown below. If you’ve never got to this point, skip down to the section on “Issues which prevent installation” below.
After installing Monkey Tools, you receive one or more Custom UI Runtime Error in MonkeyTools error messages.
Unfortunately, the implementation of the framework Microsoft provides us to customize the Ribbon interface is poorly designed to handle changes between version, as Power Query has been subject to. This means that – in order to support multiple Excel instances – our user interface has no option but to include invalid control IDs.
The good news is that these error messages can be suppressed via the following setting:
Monkey Tools was installed and appearing on your ribbon, but no longer appears when you launch Excel.
Trying to enable the add-in via File -> Options -> Add-ins -> Manage COM Add-ins -> Go and checking the box next to Monkey Tools returns the message “Not loaded. A runtime error occurred during the loading of the COM Add-in.”
The first (and most likely) cause of this issue is that Excel is be running in a hidden and corrupted instance. To resolve this:
If you find “Excel.exe” in this list:
At this point, Monkey Tools should be back on your ribbon.
If you do not find EXCEL.EXE in the list, check the next potential cause below.
The next thing to check is whether Monkey Tools has been added to the Disabled Add-ins list in Excel:
On rare occasions an issue can come up where the Monkey Tools application needs a reinstall. There is no need to uninstall the old version, just re-install using the following steps:
We currently don’t have any other issues listed here. But if you encounter an issue that you think should be covered, please take the time to:
Article Overview One of the things we have been asking the Excel team to do for a long time is give us the ability to
Why Customize the Monkey Tools Tab? The Monkey Tools ribbon was designed with one goal in mind – to make you more efficient when building
Article Overview If you’ve worked with Excel for any length of time, chances are pretty good that you have some favourite Power Queries, DAX Measures,
Process Overview The most likely reason you are at this page is because you have been directed here after logging a bug report, and we
Article Overview While we hope that Monkey Tools installs easily and keeps running, the reality is that software is a complicated thing, and sometimes things
Copyright Excelguru Consulting Inc.