excel
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
excel [2018/07/25 16:02] – [Using Data Query Formulas] corrected titles su | excel [2018/07/31 11:39] – [IP Data Query UI] minor changes su | ||
---|---|---|---|
Line 13: | Line 13: | ||
- Download the Excel Query Add-In from the [[https:// | - Download the Excel Query Add-In from the [[https:// | ||
- Run the installer | - Run the installer | ||
- | - The Add-In | + | - The Excel will launch automatically (skip step 1 in " |
=== Running the Add-In === | === Running the Add-In === | ||
- | - Double | + | - Open Excel or double |
- You may be asked if you trust the Add-In, select either " | - You may be asked if you trust the Add-In, select either " | ||
- An App Store login window will open in Excel, sign in with your App Store account | - 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:// | //You can download a spreadsheet containing examples of all the formulas [[https:// | ||
- | //Automatic Calculation must be on in order for the add-in to work properly// | + | === Updating === |
- | ==== IP Data Query UI ==== | + | To update the Add-In double click the " |
- | [[https:// | + | === Uninstalling === |
+ | |||
+ | - Open "Add or Remove Programs" | ||
+ | - Select "Excel Data Query Add-In" | ||
+ | - Click " | ||
+ | - Unsure the " | ||
+ | - Click " | ||
+ | |||
+ | 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" | ||
+ | - Click " | ||
+ | - Deselect " | ||
+ | - Click " | ||
+ | |||
+ | |||
+ | ==== The IP Data Query Tab ==== | ||
+ | |||
+ | [[https:// | ||
=== Get Current Value === | === Get Current Value === | ||
Line 82: | Line 105: | ||
=== Refresh Data === | === Refresh Data === | ||
- | This button will reload all data query formulas. | + | This button will reload all data query formulas |
+ | |||
+ | === Refresh Selection === | ||
+ | |||
+ | This button will reload all data query formulas in the currently selected range. | ||
=== Wiki === | === 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. | 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. "# | + | If a cell contains "#VALUE" that means that the query has been sent but hasn't been returned yet. "# |
=== Get Available Data Sources === | === Get Available Data Sources === |
excel.txt · Last modified: 2024/03/07 15:46 by su