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?

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?