| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to synchronize all cell values?
Im doing bussines plan with 2007 excel. Everything is in one worksheet.There is a lot of formulas and values that should be connected/synchronized, but they arent.
For example: Im doing fast food bussines, and if I raise the price of meat in cell "A2" it only changes, the cell "A3" where i counted how much meat will cost in 1 year. But cell "A20" didnt changed A20 formula is =B1-A3-A5-A7 etc... I think i must somehow update/refresh/synchronize cells, but how? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to synchronize all cell values?
Is Calculation set to Automatic?
ButtonExcel OptionsFormulas Gord On Mon, 22 Apr 2013 04:14:40 -0700 (PDT), wrote: Im doing bussines plan with 2007 excel. Everything is in one worksheet.There is a lot of formulas and values that should be connected/synchronized, but they arent. For example: Im doing fast food bussines, and if I raise the price of meat in cell "A2" it only changes, the cell "A3" where i counted how much meat will cost in 1 year. But cell "A20" didnt changed A20 formula is =B1-A3-A5-A7 etc... I think i must somehow update/refresh/synchronize cells, but how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Synchronize option button | Excel Discussion (Misc queries) | |||
| Synchronize sheets by row? | Excel Programming | |||
| Excel merge or synchronize | Excel Discussion (Misc queries) | |||
| synchronize between sheets | Excel Worksheet Functions | |||
| Excel/VBA - Synchronize combobox values | Excel Programming | |||
Linear Mode
