# Manage Tables (Excel2R)

**Manage Tables** – shows all information about linked Excel spreadsheets in the current Revit project and provides a possibility to update or delete them.

<figure><img src="https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FHYZ9kF6ck5ByXWiyA3k1%2F0.jpeg?alt=media" alt=""><figcaption></figcaption></figure>

**Select** – select the spreadsheets that will be deleted or updated.

**View Name** – View Name from the Revit project.

**View Type** – View Type in a project (Legend, Drafting).

**Excel Document Path** – path to the Excel file. If you would press on the link, then the tool will open this file with the Excel program.

**Date modified** – time when an Excel file was updated or created.

**Date loaded** – time then an Excel file was uploaded to the Revit project.

![](https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FMtgi2bEnKsVpJ0teY58R%2F1.jpeg?alt=media)

**Status column:**

<table data-header-hidden><thead><tr><th width="96">Status</th><th>Meaning</th></tr></thead><tbody><tr><td><img src="https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FHHU4IJtn51ienEOd31ZV%2F2.jpeg?alt=media" alt="" data-size="original"></td><td>File up to date</td></tr><tr><td><img src="https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FBX88osHsV2gOyNNdEbNG%2F3.jpeg?alt=media" alt="" data-size="original"></td><td>The Excel file was modified. Click Update Selected to sync changes</td></tr><tr><td><img src="https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FRqiqhesme0a68OEDNhKY%2F4.jpeg?alt=media" alt="" data-size="original"></td><td>The Excel file was moved or deleted. It needs to be reimported</td></tr></tbody></table>

### Synchronization

When Excel files are modified, all the latest changes can be synced with the Revit file. Select the modified spreadsheets and click **Update Selected**.

{% hint style="info" %}
If there are more than one spreadsheet uploaded from the **same Excel file**, but only one of them was modified, the update will be required for all the other spreadsheets as well.
{% endhint %}

![](https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2FyhIpJJSpEUfX853hJLL1%2F5.jpeg?alt=media)

![](https://239424168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqtUsszuAWXIZhQhrvjnb%2Fuploads%2F4iOds61G9gkXtdMsHsKa%2F7.jpeg?alt=media)