Drag formula down
 

Has anyone had a problem where dragging a formula down, and the new cells
display the value from the original cell even though the formula itself is
correct? If I clear the cell and reenter the formula, it calculates
correctly.

Thanks!

Drag formula down
 

Go to ToolsOptionsCalculate and change from Manual to Automatic

"TxVics" wrote:

Has anyone had a problem where dragging a formula down, and the new cells
display the value from the original cell even though the formula itself is
correct? If I clear the cell and reenter the formula, it calculates
correctly.

Thanks!

Drag formula down
 

your calculation is probably set to manual

you have to press f9 to calculate

go to tools-options-calculation and change it to automatic for it to
update automatically

mark


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=563762

Drag formula down
 

Perfect, perfect, perfect, thanks, guys!!

"MDubbelboer" wrote:


your calculation is probably set to manual

you have to press f9 to calculate

go to tools-options-calculation and change it to automatic for it to
update automatically

mark


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=563762