I can\'t see results unless i click the Save button Hi, My workbook is working s

ID: 3565359 • Letter: I

Question

I can't see results unless i click the Save button

Hi,

My workbook is working strange.

I have to save everytime when I want to see change.

Like Refresh button, I have to click save button on the left top corner.

For example, column C has formula ' Sum(A1:B1)'.

If I insert data in A1 and B1, I can't see the result in C1. I can see after I click Save button.

If I delete data in A1 and B1, the sum still remain in the cell C1. I have to click Save button, then I can see cell C1 has nothing.

What is wrong?

Thanks

Hi,

That would happen if calculation had got turned to manual. The workbook is forced to calculate before a save. Try this:-

Formulas tab | Calculation group | calculation options and ensure that 'Automatic' is checked.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.