XRL Report - Calculations switch off

VbaHell

Well-known Member
Joined
Jan 30, 2011
Messages
1,206
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
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,768
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,960
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top