Posted 8 September 2017, 2:30 pm EST
We are using FarPoint to open an existing Excel file that contains several sheets each with rather involved calculations. The file is opened using OpenExcel(fileName) method. A new tab was introduced in our file that increased the time it takes to execute this method from less than a minute to over 9 minutes.
When opened in a designer, the file opens with no noticable delay. This delay is unacceptable from the user perspective.
I attempted to turn off automatic formula evaluation in the file itself - no help. We tried to rewrite some of the calculations. I tried using the designer to save the file as XML but that saved version could not be opened by the designer itself, let alone programatically. Nothing I tried helped speed up the process of loading the file into the spread. This is now a critical issue that we need to address ASAP.
Any help would be greatly appreciated.