Recommendations

  • Use absolute cell references instead of relative cell references for faster performance.
  • Turn off automatic calculation for better performance. This is most important when using a large spreadsheet with lots of complex calculations. Set the Workbook’s Calculation Options to Manual and use the Clear/Populate Cache options to update the Spreadsheet, the Active Workbook or all open Workbooks. We do not recommend the use of the F9 key or CTRL+ALT+F9 to calculate in Excel to perform the calculations as the Excel functions make a call for every formula while the Populate Cache creates groups so fewer calls are made to the database. To set Calculation Options to Manual, go to the Formulas menu in Excel, then Calculation Options. This is an important performance recommendation.
  • Turn on caching and use populate cache whenever possible. This is a performance recommendation.
  • Be careful when using cell references, especially as they relate to dates. For example, a cell may contain an actual value like "10/14/2016", which is formatted as "2016-10-14". When you use this cell as a reference in GL functions, Excel sends the actual value "10/14/2016" instead of the formatted value "2016-10-14".