Disable Excel Automatic Calculation Results an exception

[Yanxun Hu]

Hi together

I am trying to disable automatic calculation in excel

using ExcelDna.Integration;

using Excel = Microsoft.Office.Interop.Excel;

Excel.Application app = (Excel.Application)ExcelDnaUtil.Application;
app.Calculation = Excel.XlCalculation.xlCalculationManual;

this this always throws exception

how do I go around this.

regards.

[Govert van Drimmelen]

That should work, but you probably won’t be able to call it inside a worksheet function.

 

Are you trying from a ribbon button or macro?

 

-Govert

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/6782733a-4df4-4396-b73b-31280cb55bd0n%40googlegroups.com.

[adix]

you cant access or change the .Calculation .. once a calculation is running.

This is only possible once Application.CalculationState = 0 (xlDone  = 0) | otherwise the .CalculationState = 1 (xlCalculating = 1)

I used a function with a stopwatch to catch such a situation. (max. wait 5 seconds)

You can then likewise use fixed constants like oApp.Calculation = -4105    'xlCalculationAutomatic ( -4105)

adix