Formula Calculation Mode

Add-in Express™ Support Service
That's what is more important than anything else

Formula Calculation Mode
Change calculation mode to manual 
KB LIM




Posts: 10
 Joined: 2018-01-01
Hi,

May I know how to change the calculation mode from automatic to manual when opening the Excel file?

Here are the steps:
1. User opens the Excel file. And the file was set to automatic calculation.
2. Add-in Express detected the Excel file is in the automatic calculation.
3. Add-in Express to change the calculation to manual mode.

Thanks!
Posted 15 Jan, 2023 05:16:48 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
Hello,

See Excel.Application.Calculation; https://learn.microsoft.com/en-us/office/vba/api/excel.application.calculation.

Also note https://learn.microsoft.com/en-US/office/troubleshoot/excel/current-mode-of-calculation and https://www.add-in-express.com/creating-addins-blog/2011/12/05/excel-calculation-mode-event/.

Regards from Poland (GMT+1),

Andrei Smolin
Add-in Express Team Leader
Posted 16 Jan, 2023 05:23:44 Top
KB LIM




Posts: 10
 Joined: 2018-01-01
Dear Andrei,


Thank you and I am able to do it now.

By the way, may I know how we can cancel the calculation on the workbook once it started?

Thanks!
Posted 16 Jan, 2023 22:49:40 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
Hello,

The Excel object model doesn't provide a way to achieve this.

Regards from Poland (GMT+1),

Andrei Smolin
Add-in Express Team Leader
Posted 17 Jan, 2023 13:50:01 Top