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?