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.

If your workbook is set to manual calculation, hit F9 to force the cells to
re-calculate.
--
Brevity is the soul of wit.


"DTTODGG" wrote:

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.

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.
--
Farhad Hodjat


"DTTODGG" wrote:

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.