Recalculating a report
In the user interface, there are three options to recalculate a report to retrieve up-to-date data from the database.
To recalculate an open workbook, click .
To recalculate an open worksheet, click .
To recalculate only a selected area in a worksheet, click . If you use Dynamic Arrays, the Recalculate Selected Area function works only if you select a report's top left cell (spillParent cell) or if the spillParent cell is included in the selected area.