Excel Add-in: Connect, submit and refresh

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.

  1. Open the file in Excel and open the Datarails task pane.
  2. Click Connect.
    new-home-connect.png
  3. In the Connect as Filebox window, select where the new Filebox should go and complete the required fields.
  4. Click Connect to Filebox.

The file is added to the place you chose, and the Connect button becomes Submit.

Disconnect a file

  1. Click the three dots in the top bar to open Additional options.
    new-home-options.png
  2. Click Account.
  3. Click Disconnect file.

Submit your changes

Submit sends your updates from Excel to Datarails, so the connected file there matches what you see.

  1. Make your changes in the workbook.
  2. Click Submit in the top bar.
  3. 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.

  1. Click Refresh to update everything, or click the arrow beside it to choose a narrower option.
    new-home-refresh.png
OptionWhat it doesUse it when
RefreshUpdates all data sources and recalculates all tables in the workbookYou want everything current
Refresh selected cellsUpdates only the cells you have selectedYou changed a few formulas and want a quick check
Refresh selected tablesRefreshes specific data tablesThe workbook is large and only some tables matter
Auto refresh triggersSchedules the file to refresh on its ownThe 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

  1. Click the three dots in the top bar to open Additional options.
  2. Click Settings.
  3. Turn the options you need on or off, for example Refresh data on file open or Disable Datarails Excel table refresh.
    new-settings.png

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.

  1. Click Set Date in the top bar.
    new-home-reference-date (1).png
  2. Choose the date you want to report on.
  3. 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

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request