The formulas are not automatically calculating. They work if I click on the cell (with the formula in it) and then click enter, but I have to do that on every cell...every time I change the original cell entry.
The formulas are not automatically calculating. They work if I click on the cell (with the formula in it) and then click enter, but I have to do that on every cell...every time I change the original cell entry.
Try Tools > Options > Calculation Tab > Tick Automatic
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks