excel formulas are not working

[stitthappens]

My formulas are suddenly not working anymore. I copy and paste a formula and it shows the formula is there, however the value amount is wrong. It has copied the value amount from the previous cell. I can click on the formula and delete one number and then put back that same number and now it changes it to the correct value amount. Also, I created a formula for the sum of a few cells and the formula is correct. However the amount is not correct. I can highlight those cells and see the total at the bottom and it is not the total in the formula cell.

[#2]

@stitthappens 

As variant you could be in Manual calculation mode

[#3]

@SergeiBaklan Thank you!!!!! You are a genius. That fixed everything.

[#4]

@stitthappens , you are welcome

[#5]

Hi Sergei, I'm back with another Excel issue. wondering if you know anything about it.<br><br>While attempting to save an Excel file that I rec'd from a reputable source, and a file that I was originally saving while it was in Downloads...I moved the file to another Document folder, and that appears to have caused an issue, which seems strange. Here's what the error message is saying:<br><br>"Errors were detected while saving '/Users/ericstitt/Documents/P..... Logs/WorkingBidPlus5thDay_LAT_09-26.xlsb'. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel."<br><br>What do you think?