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

Share:

Facebook
Twitter
LinkedIn

Related Posts

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

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

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

Export Model Data

Coming Soon! Sorry, but this article isn’t quite ready yet. We promise that we’re working on it! In the mean time, we did feature this

Export Model Components

Coming Soon! Sorry, but this article isn’t quite ready yet. We promise that we’re working on it! In the mean time – until we get

Import Monkey

Coming Soon! Sorry, but this article isn’t quite ready yet. We promise that we’re working on it! In the mean time – while you wait

Leave a Reply

Your email address will not be published.