How can I copy and paste the text of a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You have calculation set to Manual

Go to Tools->Options->Calculation and be sure it is set to Automatic
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I ensure formulas automatically calculate after pasting 1
using the =page! feature to transpose a row to column 0
Pasting formulas advances cell reference 2
Copy Excel functions formula and auto refresh refresh 3
Formula results don't change when it's pasted/dragged into a new c 2
How to copy & paste a worksheet but change 1 bit of the formula? 1
Copying formulas across columns 2
Copying a formula but only getting the result 3

Back
Top