Thread
:
How to synchronize all cell values?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Gord Dibben[_2_]
external usenet poster
Posts: 621
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 With Quote
Gord Dibben[_2_]
View Public Profile
Find all posts by Gord Dibben[_2_]