Use an OnOpen Macro with this line of code:
Application.Calculation = xlSemiautomatic

HTH

Charles Chickering
Dean wrote:
This is similar to a post of a few days ago which seems to have garnered zero attention, so I will simplify:

When I open up one particular file (which has data tables), I would like a macro to immediately tell EXCEL that I want to temporarily alter my normal default setting which is Tools - Options - Calculation - Automatic and, instead, use Tools - Options - Calculation - Automatic Without Data Tables.

Can this EXCEL setting be changed by a macro that automatically launches when this file is opened?

Thank you very much!
Dean