Astral Reports - Help V5:

Select the Recalculate Icon from the new “Astral Reports” Ribbon Menu to recalculate all the Business Central 365 functions on the current worksheet.

1

Figure 1 | The Recalculate Icon

It is good practice to include a “Criteria” sheet within your report to store the common data which will be passed into the function parameters. This criteria sheet will probably contain a field for the “Company Name” which will be used in every function that retrieves values from Business Central 365.

2

Figure 2 | Criteria Sheet

By re-entering this cell (F2 and Enter) excel is forced to recalculate every function that links to this cell in the entire workbook.