When I change the setting so that formulas automatically update, the formulas update...once. But the option setting is not actually changed. The automatic update feature is still set to Manual. There does not seem to be any way for me to change the setting to automatic formula update. Any ideas? THANKS!