The top bar of the Datarails task pane keeps your workbook and Datarails in step. Use it to connect a file to Datarails, send your changes, pull the latest data, and set the reporting date.
Connect a file to a Filebox
Connecting stores a local Excel file in a Filebox in Datarails. Features such as drill down, export and embedded ranges need a connected file.
- Open the file in Excel and open the Datarails task pane.
- Click Connect.
- In the Connect as Filebox window, select where the new Filebox should go and complete the required fields.
- Click Connect to Filebox.
The file is added to the place you chose, and the Connect button becomes Submit.
Disconnect a file
- Click the three dots in the top bar to open Additional options.
- Click Account.
- Click Disconnect file.
Submit your changes
Submit sends your updates from Excel to Datarails, so the connected file there matches what you see.
- Make your changes in the workbook.
- Click Submit in the top bar.
- If your Filebox uses draft and final tags, choose whether to submit as draft or final.
Hover over Submit to see when the file was last submitted.
Refresh your data
Refresh updates the workbook with the latest data from Datarails, including changes to datasets, mappings and groupings. When the database has changed, Refresh shows that new data is available.
- Click Refresh to update everything, or click the arrow beside it to choose a narrower option.
| Option | What it does | Use it when |
|---|---|---|
| Refresh | Updates all data sources and recalculates all tables in the workbook | You want everything current |
| Refresh selected cells | Updates only the cells you have selected | You changed a few formulas and want a quick check |
| Refresh selected tables | Refreshes specific data tables | The workbook is large and only some tables matter |
| Auto refresh triggers | Schedules the file to refresh on its own | The report should stay current without anyone opening it |
Hover over Refresh to see when the file was last refreshed. You can also right-click a cell and choose Refresh All or Refresh Cell.
Change how refresh behaves
- Click the three dots in the top bar to open Additional options.
- Click Settings.
- Turn the options you need on or off, for example Refresh data on file open or Disable Datarails Excel table refresh.
Set the reference date
The reference date (formerly Date Picker) sets the reporting period for your reports. Changing it moves every report that depends on it, so you can step through past periods or jump to the latest data.
- Click Set Date in the top bar.
- Choose the date you want to report on.
- Refresh the workbook to see the reports move to the new period.
Check the file's details
Once a file is connected, click the i icon in the top bar to see:
- The Filebox name
- Filebox tags, such as Date, Budget Cycle, Forecast Cycle and File Status, along with any custom dimensions your organization uses
- A banner telling you if you are not working on the latest version of the file
© Datarails Ltd. All rights reserved.
Updated