Setup
Installation
This video shows how to setup the Excel Query Add-In
Download the Excel Query Add-In from the
App Store (scroll down to the “Spreadsheets” section in the home area)
Run the installer
The Excel will launch automatically
You may be asked if you trust the Add-In, select either “Always Trust this Publisher” or “Allow for this Session”
An App Store login window will open in Excel, sign in with your App Store account
When prompted to authorize the application click “Allow Access”
Authorize your data sources by visiting
Authorized Applications. Click “Excel query Add-In” authorize any data sources you need.
The add-in will automatically load each time you open excel.
If you are prompted to log in you must reauthorize any data sources by visiting Authorized Applications.
You can download a spreadsheet containing examples of all the formulas here.
Updating
To update the Add-In double click the “Excel Query Add-In” icon on your desktop. If a new version is available you will be prompted to download it.
Uninstalling
Open “Add or Remove Programs” in settings or “Uninstall a program” in “Programs and Features” in control panel.
Select “Excel Data Query Add-In”
Click “Uninstall”
Unsure the “Remove the application from this computer” option is selected
Click “Ok”
You may start getting an error when Excel opens that says the add-in can't be found, to fix this either reinstall the add-in or remove the add-in from Excel.
To remove the add-in from Excel:
Open Excel
Dismiss the warning
Click “Open Other Work Books”
Go to Options → Add-Ins
Select “Excel Add-Ins” in the selection box at the bottom of the dialogue
Click “Go”
Deselect “Gestaltdataexcel-Addin-Packed” in the list
Click “Yes” when prompted if you want to remove the add-in from the list