---
schema_version: "1"
id: 7ac86f33e8a779f6f8046bf15f1bc11ee466ee4997746ab43576fa0c89d25f05
title: Reference Data in Spreadsheets
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/quip_spreadsheet_reference.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.quip_spreadsheet_reference.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 3dd197672c548a918431243f9c8dc9920f5434e8ea77814a168ab901134559a3
description: Show the values in a cell, range of cells, or sheet from one spreadsheet in another spreadsheet. Referenced data retains the source formatting, and it refreshes automatically when you load the spreadsheet or when the source data is updated.
products:
  - Quip
  - Cross Cloud
release: "264"
---
# Reference Data in Spreadsheets

Show the values in a cell, range of cells, or sheet from one spreadsheet in another spreadsheet. Referenced data retains the source formatting, and it refreshes automatically when you load the spreadsheet or when the source data is updated.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Quip desktop app</strong>, <strong>Quip iOS mobile app</strong>, and <strong>Quip on web</strong></td></tr></tbody></table>

To create or edit a data reference, you must have access to the source spreadsheet. Other people can see the referenced data even if they don’t have access to the source spreadsheet.

1. Click a cell in the spreadsheet.
2. From the Insert menu, select **Data Reference**.
3. Search for the spreadsheet that you want to reference.
4. From the correct spreadsheet, select the cell or range of cells that you want to reference, and then select **Reference**.

![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-anywhere_app-264-0-0-production-enus/c0406050-7b26-469a-9dc5-10d6c0c9c576/images/icon_tip.png)

Tip To compile data from several spreadsheets in a single spreadsheet, repeat steps 1 through 4 for each data set.

After you create a data reference, you can work with it in two ways:

- You can filter but not sort referenced data.
- To update referenced data, open the source spreadsheet, and edit the data.

![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-anywhere_app-264-0-0-production-enus/c0406050-7b26-469a-9dc5-10d6c0c9c576/images/icon_tip.png)

Tip When you update source data, check your data reference structure to make sure that all data remains referenced. For example, if you reference a fixed range and then add a column or row in that range, the data originally referenced in that range is cut off.

- To delete referenced data, clear the cell. Deleting a data reference doesn’t affect the source data.
- To see the source of referenced data, in the spreadsheet formula bar, select **Data Reference**.