Automatic Calculation and Refresh Mode

You can select, whether you want the values of the formula(s) to be calculated every time you enter a DR formula, or if you want to do this manually. To have values of the formula(s) calculated automatically, take Automatic Calculation into use (in desktop version, select the Automatic Calculation toggle button).

To calculate values manually:

1. Take off Automatic Calculation (in desktop version, deselect the Automatic Calculation toggle button).

2. Select an option from the Refresh Mode drop-down list:

   • Workbook: All functions in the workbook are calculated

   • Sheet: All functions on the sheet are calculated

   • Selection: All functions in the selected range are calculated.

     Note: This option only applies within the active sheet, not on multiple sheets.

3. Click Refresh.

When Automatic Calculation is selected, copy-pasting to several cells retrieves data to all included cells and also the formatting is copied. When Automatic Calculation is not selected, copy-pasting to several cells only copies the formula and the additional formatting. By default the Automatic Calculation toggle is in Off state by default (in desktop version, the Automatic Calculation check box is not selected).

Data is not automatically retrieved from the database when the Excel workbook is opened. If local Excel settings are set to automatically update external links, the formula results saved previously are not shown when the file is opened (instead, the DR formula is shown as text).

Note also that if the Calculation Options setting in Excel is Automatic and the Automatic Calculation option has been selected in DR, all reference values are updated even outside a selected Refresh Mode range when you click Refresh.