How to set calculation mode to manual within Excel application scope when opening an excel file?

[ANSHUL (MANTRI)]

Hi All,
Those who face similar issue, i found a solution as explained below:

use excel application scope
add activity “Invoke VBA code”

Save this code as => VBA.ManualCalculation.txt

        Public Function UpdateCalculation()

          Application.Calculation = xlCalculationManual
          Application.ScreenUpdating = False
            
        End Function

*Use the above code in excel application scope before processing, for eg: if you want to delete range or use copy paste range *

After the processing your logic, invoke VBA again as below:

Save this code as => VBA.AutomaticCalculation.txt

Public Function UpdateCalculation()
   
  Application.Calculation = xlCalculationAutomatic
  Application.ScreenUpdating = True

End Function

Before using the Manual Calculation mode the overall processing took 10 min to update the excel, now its just 34 seconds. Give it a try…!!

If you face any issue invoking the VBA, refer to the settings here:

Error: Invoke VBA: Programmatic access to Visual Basic Project is not trusted

Hello! I tried to import a macro from excel in the project to add filters to my columns, but it gives me this error: [error] I mention that i checked the Trust access to the VBA project object model, under Macro Settings in Options. Please help me . Thank you!

thanks to @Palaniyappan.

Best Regards.