Disable Formula Calculation in MS Excel while opening Workbook created by Aspose.Cells for .NET in C#

Aspose.Cells Product Family
1

Hi all,

Can i disable all formula until i call cal method for speedup?
Tks for support
2

Hi,


If you need MS Excel to ignore calculating formulas in the Workbook while opening the file into MS Excel (MS Excel does this for default settings), please try:
e.g
Sample code:

workbook.Settings.CalcMode = CalcModeType.Manual;
workbook.Settings.ReCalculateOnOpen = false;

Let us know if we can be of any further help.

Thank you.
3

Hi,

Tks Amjad Sahi. That`s answer.
4
Hi,

Good to know that it figures out your issue now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.