Jet reports should be run with Excel's "Automatic Calculation" mode
When running Jet Reports, please ensure that Excel's Workbook Calculation mode is set to Automatic.
Running Jet Reports when Excel's calculation mode is set to "Manual" can cause unreliable results.
This is a workbook-level setting.