When I open up one particular file (that has data tables), I would like a macro to immediately tell EXCEL that I want to temporarily alter my normal default setting which is auto recalc, in favor of auto recalc without data tables. Can this EXCEL setting be changed by a macro that automatically launches when this file is opened? Here is the macro I pasted (I didn't create it per se, in case it matters) into the "This Workbook" object, but it doesn't seem to be working.

Private Sub Workbook_Open()
With Application
.Calculation = xlSemiautomatic
.MaxChange = 0.01
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub

Thanks much!
Dean