Slow incremental recalculation

Slow incremental recalculation

Posted by: dean.kinnear on 4 September 2025, 8:38 am EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 September 2025, 8:38 am EST - Updated 4 September 2025, 10:36 am EST

  Please find attached workbook. Each incremental recalculation takes over 40 seconds to complete. For comparison, the same workbook recalculates nearly instantaneously in Microsoft Excel.

  Could you please investigate and advise on a potential cause or solution?
  
  Thanks!

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 4 September 2025, 4:07 pm EST

  I am still investigating, but it looks like UDFs are running and slowing down the calculation process

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 8 September 2025, 4:28 am EST

  Hi Dean,

  Thanks for reaching out. I noticed in your message that you mentioned an attached workbook, but I wasn’t able to find any file. Could you please resend the workbook so that we can investigate the recalculation performance on our end?

  From your follow-up, it seems like UDFs (user-defined functions) may be involved, which could explain the slower calculations compared to Excel. Once we have the file and a working sample, we’ll be able to confirm whether UDFs or any other factors are contributing and suggest the best way forward.

  In case the workbook contains some confidential data, you can share it with us on our private support portal at https://developer.mescius.com/my-account/my-support.

  Kind Regards,
  
  Chirag Gupta