Differences

This shows you the differences between two versions of the page.

--- excel [2018/07/25 16:02] – [Using Data Query Formulas] corrected titles su
+++ excel [2018/07/31 11:37] – Updated install instructions su
@@ Line 13: / Line 13: @@
   - 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 Add-In will launch automatically (skip step 1 in "Running the Add-In")
+  - The Excel will launch automatically (skip step 1 in "Running the Add-In")
 === Running the Add-In ===
-  - Double click the "Excel Query Add-In" icon on your desktop to launch the Add-In
+  - Open Excel or double click the "Excel Query Add-In" icon on your desktop to launch the Add-In
   - 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
@@ Line 26: / Line 26: @@
 //You can download a spreadsheet containing examples of all the formulas [[https://appstore.intelligentplant.com/nuget/downloads/IP Excel Addin example.xlsx|here]].//
-//Automatic Calculation must be on in order for the add-in to work properly//
+=== 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 and open a work book
+  - Go to File -> 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
 ==== IP Data Query UI ====
@@ Line 82: / Line 105: @@
 === Refresh Data ===
-This button will reload all data query formulas.
+This button will reload all data query formulas in the currently opened sheet.
+=== Refresh Selection ===
+This button will reload all data query formulas in the currently selected range.
 === Wiki ===
@@ Line 98: / Line 125: @@
 Once you have written (or edited) a formula press Ctrl + Shift + Enter to update the effected range, if you forget to do this you will get a "You can't change part of an array" error from Excel.
-If a cell contains "#GETTING_DATA" that means that the query has been sent but hasn't been returned yet. "#N/A" means that there is no result for that cell (i.e. the range you selected is larger than the number of returned data points).
+If a cell contains "#VALUE" that means that the query has been sent but hasn't been returned yet. "#N/A" means that there is no result for that cell (i.e. the range you selected is larger than the number of returned data points).
 === Get Available Data Sources ===