Monkey Tools

Options Monkey

Article Overview

What is an application with Options? Monkey Tools is no difference, and we have a specific Options Monkey to help you control them all.  This article discusses how this particular Monkey works, as well as explains what some of the options actually do.

The Options Monkey's Version Tab

Version Info

In this section, the Options Monkey tells you what version you are running, and when the last Monkey Tools update was installed.  By default, Monkey Tools will automatically check for updates every 14 days, but you can set this value higher or lower as desired. Want to check immediately? Click the “Check for Update Now” button, and we’ll let you know if an update is available for installation.

License Info

This section of the Options Monkey is covered in detail in the article on Activating Your License.

The Options Monkey's Version tab allows you to configure the number of days between update checks, and activate your Monkey Tools license

The Options Monkey's Reset Forms Tab

The Reset Forms tab of the Options Monkey allows resetting one, several or all of the Monkey Tools forms

Our Monkeys make use of a lot of forms, many of which store your choices to use as defaults for next time.  Should you ever need to reset one or more forms to their default states, however, the Options Monkey has you covered.

To reset one or more forms:

  • Check the box next to the form(s) you wish to revert to default
  • Click Reset

Or, if you’d like to reset everything quickly:

  • Click Select All
  • Click Reset

It’s just that easy!

The Options Monkey's Global Options Tab

This section of the Options Monkey contains a few specific options which may need a bit more explanation:

Office 365 introduced new PivotTable buttons in the ribbon. While this is awesome, Microsoft doesn’t give us a way to conditionally test and return the correct buttons for you.

If you don’t see any buttons in the PivotTables section at the top of the Monkey Tools Pivots & Filters menu, try checking this setting. We’ll add the legacy Insert PivotTable and Recommended PivotTables button there for you.

Note that this choice will “stick” when you re-launch Excel.

Are you curious what you’d lose if your trial expires, or if you decided to let your Pro license revert to free?  Wonder no more! Just check this button, click close, and go use Monkey Tools.

Note that this feature is only available for Pro and Pro Trial users, and does not stay checked when Excel is restarted, as we don’t want you to lose out on your Pro license benefits!

A few of our Monkeys require some very in-depth analysis of your Power Queries in order to provide you with the best experience possible.  (Calendar Monkey and SCD2 Monkey are just two examples of these.)

The challenge is that – in order to get this information – these Monkeys actually create and run a query to extract the data they need.  It’s cool, but can lead to a couple of concerns:

  1. If privacy levels have not been defined for all of your data sources (including your host workbook), the query can fail to load.
  2. Depending on the number and type of data sources, as well as the complexity of your queries, these can take a while to load.

If you are experiencing significant latency when trying to load our Monkeys, you can Disable this feature.  Just be aware that – while things may get faster – our Monkeys won’t be able to provide you with the useful defaults you are used to.

It’s unlikely you’ll use this feature unless we ask you to, but should you need to send us a log, here’s how to do it:

  1. Check the Enable Error Logging checkbox
  2. Optionally, check the Detailed error logging box as well (that just gives us more detailed info.)
  3. Make sure you take note of the error path so you can find the file to send to us.

Note that this feature is turned off when Excel loads. (We don’t want to fill your hard drive with log files!)


Global Options controlled by the Options Monkey include legacy PivotTable buttons, show the user interface in Free mode, Disable Enhanced Query Metadata Analysis and Error Logging



Related Posts

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

We can customize the Monkey Tools Tab to ad existing Excel commands to it

Customize the Monkey Tools Tab

Why Customize the Monkey Tools Tab? The Monkey Tools ribbon was designed with one goal in mind – to make you more efficient when building

Biblo Monkey

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,

Submitting Error Logs

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

Installation and Activation Issues

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