"snap" wrote:

I have an excel worksheet that use to work fine. Now all of a sudden the cell
with a formula no longer updates automatically. It only updates the
calculated cell once I save the file.

You may have accidently turned off automatic calculation. Check
ToolsOptionsCalculation and see if the Automatic radio button is selected