Calculation Options
Multiple options are available for retrieving and calculating data in Reporting Intelligence.
- By default, the calculation function in Excel is set to calculate automatically. insightsoftware recommends setting this value to manual, so all required spreadsheet changes or additions can be completed prior to recalculating.
- The following options are available for calculating spreadsheets:
- F2+Enter: calculates the active cell.
- F9: calculates all worksheets in all open workbooks.
- Shift+F9: calculates the active worksheet.
- Ctrl+Alt+F9: calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Tip: The majority of these options are also available from the Reporting Intelligence Ribbon, by clicking Recalc button drop-down list, then selecting the appropriate option.