Recommendations

  • Use absolute cell references instead of relative cell references for faster performance.
  • 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".