XRL Report - Calculations switch off

[VbaHell]

Hello all

This is a bit of a strange request

I update a report with an add on tool in Excel called "XRL"

When the report is updated "XRL" has switched the calculations function off.

I thought of trying a worksheet event change to switch the calculations back on but this is not working unless I physically enter the cell and change to trigger the event.

Has anyone come across this issue and found a fix please without having to remember to switch the calculations back on manually

 

[Jeffrey Mahoney]

Can you edit the Addin Code? If so, look for a statement like this and add the opposing statement to turn calculations back on.

OR

Try adding these two SUBS into the "Thisworkbook" module in the VBA project that XRL is changing. If that is often a different file, then I'm not sure.

Private Sub Workbook_Activate()
Application.Calculation = xlCalculationManual
End Sub


Private Sub Workbook_Deactivate()
Application.Calculation = xlCalculationAutomatic
End Sub