Stop Excel dates from updating on open by replacing volatile formulas with static values or disabling automatic data connection refreshes.