Share worksheets

You can share worksheets with users or with groups.

Sharing a worksheet allows users to select it as a data source and search it. When you share a worksheet, you give users or groups within your cluster access to the worksheet’s data. You share all of its columns. Sharing a worksheet does not share the underlying tables. If you want to share the underlying tables, see Sharing tables and columns.

If you want to migrate the worksheet to another cluster, or otherwise export it, see Migrate or restore objects.

A worksheet can be shared by the owner of the worksheet, or by an administrator. Users can start searching a worksheet as soon as the worksheet is shared with them.

You can share a worksheet from the list of worksheets under worksheets on the Data tab, or from within the worksheet.

Share from the Data tab

To share a table, worksheet, or view from the Data tab, follow these steps. You can also share multiple objects at a time from the Data tab.

  1. Click Data on the top navigation bar.

  2. Hover over the dataset you want to share and select it by clicking the empty checkbox that appears.

  3. Click Share.

    Share the data

  4. If you are sharing a table, select Entire Table or Specific Columns. To use Column Level Security (CLS), select Specific Columns, and only share the columns the users or groups should have access to.

    Specify sharing type

    The option to share specific columns is only available for tables, not for Worksheets or Views.
  5. If you select Specific Columns, select the column(s) you want to share, and add the users or groups you want to share the column(s) with. Use this option for Column Level Security (CLS). If you select Entire Table, skip to step 6.

    You cannot click multiple columns at once. You must input the users or groups with whom you want to share for each column.
  6. Click + Add users or groups and select the users and groups with whom you want to share.

  7. Specify permissions.

Share from within the dataset

To share a table, worksheet, or view from within the dataset, follow these steps.

  1. Navigate to the dataset you want to share.

  2. Click the More menu icon more options menu icon, and then click Share.

    Share the data

  3. Select the users or groups with whom you want to share.

    You can only share the entire dataset. You cannot share individual columns. To share individual columns, share a table from the Data tab. You cannot share individual columns for worksheets or views.

  4. Specify permissions.

Specify permissions

  1. Configure the level of access by selecting from the dropdown list. You can select:

    • Can View to provide read-only access. This enables viewing the data source’s data. If the data source is a table, Can View also enables defining worksheets based on that data.

    • Can Edit to allow modification. This enables renaming, modifying, or deleting the entire data source and adding or removing its columns.

    Specify permissions
  2. Click Add.

  3. Click Done.

  4. The Share settings updated notification appears on the bottom of your screen.


Was this page helpful?