How to Update an Excel Document from Displayr

This article describes how to update Excel documents you exported from Displayr. It also explains how to update your Excel exports by adding additional table(s) to an existing Excel file without having to manually combine each Excel export into a single Excel file.

Here is a summary of this feature:

Any tables that were previously exported by Displayr are updated with the latest data, including:
- Table cell data
- Table labels
- Row/column headers
- Captions/footers
Any tables that are now present in the Displayr document but not in the Excel file are appended to the Excel file.
If a Table of Contents is present in the Excel file, it is updated too.
Upon completion of an update, Displayr will show a summary with a log of every item that has been updated (similar to the PowerPoint Updating summary). Users can download the log in .txt format. It logs the following:
- A table is successfully updated
- A table was found in the Excel file, but not in the Displayr document - not updated.
- A table was present in the Displayr document but not in the Excel file - appended to the file.
Any charts already present in the Excel file will have their chart settings retained. The underlying table data (if linked to a Displayr table) will be updated with the new data.

Updating a table you previously exported to Excel

Let's say you previously exported the table on the left to Excel. Later, you decide to combine some of the categories together in Displayr and want to update the table in Excel:

This is what the table looks like in Excel prior to updating it.

To update the existing Excel table:

In the Report tree, select the table you want to update.
Make the desired changes to the table.
Go to Share > Export Report > Excel.
Choose which page(s) you want to export. You can either export all pages or selected pages.
Select Update existing document
Drop your Excel file into the box or click to browse for the file.
Click the Export button. A log of what changed is displayed. You can either download the log or simply close the log.

The updated results in Excel are as follows:

Updating an Excel document with additional tables

Let's say that you want to append the following table to the bottom of your Excel document:

In the Report tree, select the pages that you want to export. If you don't want to export all of the pages, select only the pages that contain the additional/new tables.
Go Share > Export Report > Excel.
Choose which page(s) you want to export. You can either export all pages or selected pages.
From the Export to Excel dialog, select Update existing document.
Select the Excel file you want to update by dragging the file into the box or browsing for the file.
Click the Export button. A log of what changed is displayed. You can either download the log or simply close the log.