Dashboard File Does Not Automatically Calculate Formulas Without a Refresh

When a dashboard is saved from Estimator and opened in Excel, sometimes the calculation of the automatic formulas is disabled, requiring you to manually refresh the file (F9) for the changes to take effect.

This can be easily solved by changing the formulas to update automatically in Excel.

Open the file that you saved: Next, click File on the tab bar > Options > Formulas

In the Calculation Options, change to Automatic and click OK.

mceclip0.png