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?

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.

"tomcat" wrote:

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?

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Pritesh Shah" wrote in message ...
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.

"tomcat" wrote:

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?

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


"tomcat" wrote in message
...
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?

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.

---
Regards,
Norman


"CLR" wrote in message
...
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


"tomcat" wrote in message
...
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?

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

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

---
Regards,
Norman



"Norman Jones" wrote in message
...
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.

---
Regards,
Norman


"CLR" wrote in message
...
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


"tomcat" wrote in message
...
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?

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

---
Regards,
Norman



"Norman Jones" wrote in message
...
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.

---
Regards,
Norman


"CLR" wrote in message
...
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


"tomcat" wrote in message
...
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?

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.

"CLR" wrote:

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


"tomcat" wrote in message
...
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?