How do I copy formulas from one wkb to another w/out linkng them?

[tomcat]

I want to copy a formula from one work sheet to another without the formula
making a link in it...
I am using the latest excel version. Is there any way to make it "NOT"
insert the link to the copied spreadsheet?

 

[Pritesh Shah]

Dear Tomcat,
Easy way of doing it is, edit the formula in formula bar, then copy the
formula as as plain text and then paste it to the place you wish to paste.
Excel will simply understand it as currently typed formula.
Rgds,
PDS.

 

[David McRitchie]

If you want to paste a group of cells as formulas (unchanged)
Right Click Menus (Context Menus) in Excel
http://www.mvps.org/dmcritchie/excel/rightclick.htm

CopyFormula and PasteFormula are the macros, but since you have to install a macro
and put something into your AutoOpen, you might as well consider
all of them. The concept was Chip Pearson's, and was modified
by Drew Patterson but there were errors and you would have to read
the entire thread so I made it easier and included macros of my
own as well.

 

[CLR]

If I'm only doing a few, I just delete the equal sign which turns the
formula into TEXT and then it copies fine, then just re-insert the equal
sign to turn it back into a formula again.....

Vaya con Dios,
Chuck, CABGx3

 

[Norman Jones]

Hi Chuck,

If I'm only doing a few

And, if it a common task, see the last section of Chip Pearson's 'Working
With The Windows Clipboard Page'

I followed Chip's suggestion and have frequent cause, silently, to thank
him as I right-click.

 

[Norman Jones]

Sorry, I dropped the link to Chip's page:

http://www.cpearson.com/excel/clipboar.htm

 

[Norman Jones]

And, when I replied I didn't see David's post!

 

[tomcat]

Thank you - so far this has been the easiest method to use...but it seems SO
odd that sometimes I can copy formulas without making links to the copied
page and other times it makes them... almost like there should be a
"relative switch" somewhere.

K.