Understanding "Calculating Cells"

G

Guest

Hello-

Could someone kindly explain what "calculating cells" does and does not do?
I have a pretty big spreadsheet that is getting out of control. Reading
other posts, it looks like I could set to "manual calculate". But, this is a
shared file and I don't know if the other person would know to "calculate or
not to calculate" - that is the question!

If the other person is only doing data entry, sorts and filtering. Could I
set it for manual calculation?

Specifically, when and what and why does it calculate?
-If I copy a row that has formula or vlookups, do I need calculate on?
-Do I need calculate on when it first opens and does the updating of cells?
-If I have it off and open the file, will it update incorrectly or not at all?

Thank you for your time.
 
G

Guest

If your workbook is set to manual calculation, hit F9 to force the cells to
re-calculate.
 
G

Guest

If you saw the word "Calculate" in the middel left side of status line (the
line in the bottum of Excel window where you see Ready in the left side) then
you need to re calculate by hitting F9.
 

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

Top