We have a spreadsheet that uses formulas mostly VLookups in about 2000 rows. we write and read a range of values to the spreadsheet extremely fast, but the calculateformula method call that we have to make inbetween the write and read actions takes qute a bit of time to run, relative to other third party spreadsheet components. Judging from other posts, this has been an ongoing issue for several years now. Do you have any plans to focus on improving the performance of this method for a release and if so when?
Could you try latest version:
If you still find the issue, kindly attach your template file and also mention how much time the workbook.CalculateFormula() method takes, we will check your issue soon.