To import data from Wdata into a spreadsheet, you can connect a query to each sheet. To view and manage all of the spreadsheet's connected queries, click Wdata Connections in the right panel. From the Wdata Connections panel, you can view details about the queries connected to each sheet of the spreadsheet, and 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 menu.
Connect a Sheet to a Query
Note: To update a connected sheet's connection to Wdata, you may need to first migrate the connection from the Connected Sheets panel.
If you're a spreadsheet's Owner, you can connect each of its sheets to a query you have permission to view in Wdata from the Wdata Connections panel.
- 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 Spreadsheet's Connected Queries
If you're a spreadsheet's Owner or Editor, you can refresh its connected queries from the Wdata Connections panel to update with the latest data. To update a sheet, click its Refresh Connection .
Update a Connected Query's Parameters
If a query includes parameters, you can set the criteria of the data to include in it 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.
Remove a Connection
To remove the connection between a sheet and Wdata, such as to connect to a different query, select Remove Connection from the sheet's menu on the Wdata Connections panel.
Collaboration in Wdata Connections
If you're a spreadsheet's Owner, you can connect its sheets to queries you 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|