Autosum not displaying until spreadsheet saved

D

DickFoto

I have a spreadsheet where a column is being autosummed (=sum(A1:A16)). The
figure does not appear in A17 until the worksheet is saved. Why?

Something I discovered - the amount in A17 is being used in calculations in
another column. That calculation is being used in a third. Is this the
reason the autosum answer does not appear in A17 until CTRL-S is pressed or
the worksheet is saved?

If this is the case, can you point me to the specific rule or explanantion
so I can share this with others?

Thanks!
 
K

Kevin B

Sounds like your calculation mode is set to manual with recalc on save set to
yes.

Go to TOOLS/OPTIONS and click the CALCULATION tab and set it to AUTOMATIC
 
D

David Biddulph

Perhaps you've got the calculation mode set to manual, instead of automatic?

Tools/ Options/ Calculation
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table of content - format does not get saved 2
An odd problem with SUM(A:B) and AutoSum 2
Menu Macro Not Executing - Need Help 1
Setting column width in a table with a macro is not working 0
White space above heading inconsistently applied 1
creating multiple worksheets from one 0
SUMIFS ONLY UNTIL the number REPEATS 1
SUMIFS UNTIL the number is repeating 0

Top