Editing a Query
About this task
The Edit Query feature allows you to change query parameters such as tag name, start time, end time, and so on, in Excel. The Edit Query dialog box that displays is based on the type of query you are editing. For example, if you want to edit a calculated query data then the Calculated Edit Query dialog box appears.
You can use the Edit Query feature to request more data than is currently displayed or you can select an output range that does not overlap the current range. However, you cannot make the output range smaller. For example, a query edit that changes the NumberOfSamples or the Output Orientation to values that result in fewer rows or columns will not work.
Procedure
- From the Add-in drop-down list, select the Edit Query from the Add-In drop down list or click the
icon or double click any cell which has the query formula. The Edit Query dialog box appears with the existing query data.