excel:getting-started
Table of Contents
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
excel/getting-started.txt · Last modified: 2018/08/03 15:24 by su