To import data from Wdata into a spreadsheet, you can connect a query to each sheet. From the Wdata Connections panel, you can:
- View and manage the queries connected to each sheet of the spreadsheet
- Adjust the parameters of connected queries
- Refresh connections to update the spreadsheet's data
Note: On the panel, the current sheet of the spreadsheet appears with a black bar. To open a connected sheet, select Go To Sheet from its connection's menu.
Wdata connections and spreadsheet cells
To ensure data integrity, Wdata connections lock their sheets' connected cells. In the formula bar, a cube appears for a cell connected to a Wdata query. To update the data in a connected cell, refresh the connection.
When you add or refresh a connection, it also automatically removes any data from its sheet's unlocked cells. To retain a calculation or other data in the sheet, lock its cell.
Note: To determine which cells are locked, click Overlay on the View toolbar. In Overlay, cells locked by a Wdata connection appear green; other locked cells are gray.
Connect a query to a sheet
Note: To update a connected sheet's connection to Wdata, you may need to first migrate the connection from the Connected Sheets panel.
From the Wdata Connections panel, a spreadsheet's Owner can connect each sheet to a query they have permission to view in Wdata. You can connect up to 30 queries to a spreadsheet.
- In the spreadsheet, select the sheet to connect to a query.
- From the Wdata Connections panel , click Add Connection .
- Select the query to connect to the sheet, and click Next.
- Set any parameters for the query, and click Connect.
To open a connected query in Wdata, click its name, or select Open Source from its sheet's menu.
Note: Each sheet can have only one connection. If collaborators simultaneously add multiple connections to a sheet, it uses the most recent connection; other connections appear as Overridden so you can choose which to use.
Refresh a connection
To update a sheet with the latest query results, a spreadsheet's Owner or Editor can refresh its connections from the Wdata Connections panel:
- To run a specific connection's query, click its Refresh connection .
Note: You can refresh multiple connections at the same time.
- To run all connected queries, click Refresh connections on the panel.
To cancel a connection's refresh, click its X.
Update a connected query's parameters
If a query includes parameters, you can set the criteria of the data to include in its connected sheet, such as to roll its time period forward or back. To update a query's parameters:
- On the Wdata Connections panel, select the connection.
- Under Parameters, select the criteria of the data to include in the connected sheet.
- Click Apply & Refresh.
Rename a connection
By default, each connection uses the same name as its connected sheet. To edit a connection's name, select Rename Connection from its menu on the Wdata Connections panel.
Replace a connected query
To change the query connected to a sheet:
- From the Wdata Connections panel, select Replace Source from the connection's menu.
- Select the query to connect to the sheet instead.
- Set any parameters for the new connection, and click Replace.
Remove a connection
To disconnect a sheet from its query, such as to retain the snapshot of its data, select Remove Connection from the connection's menu on the Wdata Connections panel.
Collaboration in Wdata connections
A spreadsheet's Owner can connect its sheets to queries they have permission to view in Wdata.
If you collaborate on the spreadsheet with others, their access to a connection depends on their permissions to the query and sheet:
| Query permission | Sheet permission | Connection access |
|---|---|---|
| Viewer, Editor, or Owner | Viewer or None | Locked |
| Viewer | Editor | Refresh the query and update its parameters |
| Editor or Owner | Owner | Full access |