The add-in lets you generate and share reports with both Datarails and non-Datarails users, whether you are sending them to stakeholders inside your organization or to external recipients who do not use Datarails.
This article covers how to export reports so formulas and dynamic data are either preserved or converted to static values for broader compatibility.
In the task pane, go to Management > Export.
Exporting saves values as static. The exported file does not update dynamically the way your working file does. Export only finalized data when you need to share accurate, non-changing information.
Your file must be connected to your Datarails environment to use Export.
the Export section in the task pane, showing its three options
Export as values
When sharing a report with people who do not have the Datarails add-in, you need to remove the Datarails formulas. Without the add-in, formulas such as DR.GET produce errors on their machine. Exporting as values prevents that.
- Open the Excel report you want to export.
- Go to Management > Export.
- Choose Export as values.
- Select the destination folder and save the new file.
- A new report is created containing static values, ready to share with anyone.
Export as PDF
To share a report in a non-editable format, export it directly to PDF.
- Open the Excel report you want to save as a PDF.
- Go to Management > Export.
- Choose Export as PDF.
- Select the destination folder and save the new file.
- A new PDF is created containing the report values.
Create report by filter
Instead of exporting the same report over and over by hand, you can generate one version per filter value: a separate financial statement per department, or a sales report per region, from a single report.
Add a filter - You need a saved filter in the workbook before you can split by it. A filter applies across every table that shares the field. See Filters.
Submit the file at least once - The option is unavailable until the file has been submitted to Datarails.
Split a report
- Go to Management > Export and choose Create report by filter.
- From Select filter, choose the filter to split on. Selecting a Department filter, for example, gives you one report per department.
- From Select values to export, choose the values you want reports for. All values are selected by default. Each selected value produces its own report. You can create up to 1,000 reports per run.
- Configure the export options:
| Option | What it does | Default |
|---|---|---|
| Save as values | The reports contain static values instead of Datarails formulas, and are not connected to Datarails | On |
| Keep dynamic ranges | The reports keep their dynamic ranges | On |
| Save to PDF | The reports are created as PDFs instead of Excel workbooks. While it is on, the other two options do not apply | Off |
- Click Apply - The pane shows the progress, and you can click Cancel to stop after the current report.
When the run ends, the add-in puts your original filter selection back and refreshes the workbook.
If values were added to the filter while this pane is open, click Refresh to load them.
Create report by filter pane, with the Department filter chosen and the three export toggles
A report created without Save as values is still connected to the same filebox as the original file. If you submit it, it uploads a new version to that filebox. Turn on Save as values for reports you are sending out.
Which option to use
| You want to | Use |
|---|---|
| Share numbers with someone who does not have the add-in | Export as values |
| Share a fixed, non-editable copy | Export as PDF |
| Produce one tailored version per audience | Create report by filter |
| Keep the report live and connected | Do not export. Share the file through Datarails instead. |
Working across platforms
Export behaves identically on Windows desktop, Mac desktop and Excel on the web.
© Datarails Ltd. All rights reserved.
Updated