===== Setup =====

==== Installation ====

[[https://www.youtube.com/watch?v=ab0DvCzBOy4&index=2&t=0s&list=PLsVwx5rtV9c0duV5jln2IX9BIMDCCEWrY|This video]] shows how to setup the Excel Query Add-In

  - Download the Excel Query Add-In from the [[https://appstore.intelligentplant.com/|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 [[https://appstore.intelligentplant.com/Security/Apps
|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 [[https://appstore.intelligentplant.com/Security/Apps
|Authorized Applications]].**

//You can download a spreadsheet containing examples of all the formulas [[https://appstore.intelligentplant.com/nuget/downloads/IP Excel Addin example.xlsx|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