View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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