Menu
I have to input several hundred cells into an excel sheet from a C# program. Each time I set a cell or a range, excel slowly responds... presumably updating various outputs between each input I add. Is there a way to disable calculations from my C# program, and re-enable it after I am done setting cells and ready to read the outputs?
613
Check for Automatic Recalculation On the Formulas ribbon, look to the far right and click Calculation Options. On the dropdown list, verify that Automatic is selected. When this option is set to automatic, Excel recalculates the spreadsheet's formulas whenever you change a cell value.
Manual calculation shortcuts In Manual mode, you can refresh formulas by pressing F9. You can also click the Calculate Now or Calculate Sheet buttons in the Formulas ribbon. This can help you save time and avoid the stress of waiting for Excel to finish updating formulas!
Yes, set the Application.Calculation to xlCalculationManual, then back to xlCalculationAutomatic.
You can also consider setting Application.ScreenUpdating to false and then back to true.
153
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
