# Link Odoo data

> You can insert and link several elements from your database in your spreadsheets, namely:. Passo a passo no Odoo 16 com a localização brasileira, pela KMEE.

Fonte: https://docs.kmee.com.br/odoo/enterprise/modulos/documentos-e-planilhas/vincular-dados-na-planilha/

You can insert and link several elements from your database in your spreadsheets, namely:

- pivots,
- graphs,
- lists, and
- links to menus (i.e., a clickable link to a view of a specific model).

Before inserting [pivots](https://docs.kmee.com.br/odoo/enterprise/modulos/primeiros-passos/relatorios/#reporting-views-pivot), [graphs](https://docs.kmee.com.br/odoo/enterprise/modulos/primeiros-passos/relatorios/#reporting-views-graph), or lists, ensure they are tailored to your needs, as some elements are more quickly - or only - configurable in their respective view.

- To insert pivots and graphs, click **Insert in spreadsheet** from any pivot or graph view.
- To insert lists, click **Favorites -> Insert list in spreadsheet** from any list view.
- To insert links to menus, click **Favorites -> Link menu in spreadsheet** from any view.

In the pop-up box, either create a new spreadsheet by selecting **Blank spreadsheet** or insert it in an existing one by selecting it and clicking **Confirm**.

![Inserting a pivot in a spreadsheet](https://docs.kmee.com.br/odoo/referencias/img/applications/productivity/spreadsheet/insert/insert-spreadsheet.png)

Nota

By default, new spreadsheets are saved under the **Spreadsheet** workspace of the Documents app.

[]()

## Updating data

Once inserted in a spreadsheet, your data is kept up-to-date, reflecting any changes made to your database. Reopening the spreadsheet reloads the linked data.

Nota

To update pivots and lists data without reopening a spreadsheet, go to the menu bar and click **Data -> Refresh all data**.

### Pivot data

Using **Refresh all data** only updates existing pivot cells. If new cells need to be added, go to the menu bar and click **Data -> Re-insert pivot** to fully update the pivot. Alternatively, click **Insert pivot**, select the pivot, and tick **Display missing cells only** to preview first the missing data.

> ![Displaying missing cells in a pivot](https://docs.kmee.com.br/odoo/referencias/img/applications/productivity/spreadsheet/insert/missing-cells.png)

To change which records are [used by the pivot](https://docs.kmee.com.br/odoo/enterprise/modulos/primeiros-passos/pesquisar-e-filtrar-registros/#search-preconfigured-filters), right-click on a pivot cell, select **See pivot properties**, and click **Edit domain**.