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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I copy and paste the text of a formula? (https://www.excelbanter.com/excel-worksheet-functions/43077-how-can-i-copy-paste-text-formula.html)

Jeff

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

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

Duke Carey

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

All times are GMT +1. The time now is 05:46 AM.