You have calculation set to Manual
Go to Tools-Options-Calculation and be sure it is set to Automatic
"Jeff" wrote:
I am looking for a way to paste an Excel formula into another cell and have
the formula calculate automaticly.
EXAMPLE:
Paste ='TT Rate Plan'!G3577 into another cell and have the result of the
formula appear.
I have a unaceptable workaround by clicking on the cell and pressing enter.
This reveals the result but I need to do this 10,000 time.
Thanks in advance.
Jeff
|