Incoming connections
A sheet's owner can connect a sheet to only queries, sheets, and reports they have permission to view.
If you collaborate on the spreadsheet with others, their access to its connections depends on their permissions to the sheet and query.
| Source permission | Sheet permission | Connection access |
| Viewer, Editor, or Owner | Viewer or None | Locked |
| Viewer | Editor | Refresh connection |
| Editor or Owner | Owner | Full access |
Related Articles
- Connect pivoted data to spreadsheets with crosstab queries
- Connect sheets to source Wdata queries
- Connect sheets to source or destination spreadsheets
- Connect sheets to source Reports
- Connect a presentation's tables and charts to Workiva sources
- Share queries between workspaces
Outgoing connections
A source sheet's owner can connect it to a Wdata table that they have permissions to edit. When connecting a sheet to a table, its data appears on the table as a connected dataset which you can refresh from the table or spreadsheet.
| Sheet permission | Destination permission | Connection access |
| Viewer, Owner, or Editor | Viewer | Locked |
| Editor | Editor or Owner | Refresh connection |
| Owner | Owner | Full access |