Settings for the Excel Add-in

In addition to the following three options, the Settings menu is also where you will find a link to the About menu, where you can check the version number, the privacy policy and review a list of third-party software used by the add-in.

 

Select data range when editing a query.

When opening the edit query panel, automatically select the cells where the results of the query are located.

Deselect if you have typically have other cells selected and do not wish to have the selection area change.

Select data range when running a query.

When running a query by using the refresh button, this selects the cells where the results query are located.

Show welcome screen.

The welcome screen is shown automatically when the history query panel is first opened.