Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Understanding "Calculating Cells"
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Understanding "Calculating Cells"
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Understanding "Calculating Cells"
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reduce "Calculating Cells" ? | Excel Discussion (Misc queries) | |||
Inserting new data before "calculating cells" is done??? | Excel Discussion (Misc queries) | |||
Understanding SUMPRODUCT | Excel Worksheet Functions | |||
Price Function - Difficulty in understanding the formula | Excel Worksheet Functions | |||
Understanding Checkbox function | Charts and Charting in Excel |