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

[tomcat]

How do I copy a formula from one workbook to another so that the pasted
formula does NOT have a link back to the copied workbook...... WITHOUT
redirecting/editing the Link?

 

[milazalu]

Hey,

try to mark the cell you want copy, than go to the cell in another workshhet
and go to the "edit - paste special - formula" or HOTKEY: ALT+E, then S, then
F
it should help you...

tomcat píše:

 

[Dave Peterson]

Maybe copying from the formula bar and pasting into the formula bar will do what
you want.

 

[Ross]

Copy the formula as it is. Select Edit Links, highlight the link you
want to change, select 'Change Source' and pick the spreadsheet you are
in. Click OK and you'll find the cell reference is in your current
spreadsheet.

 

[tomcat]

I tried this and the link still copies. Thanks for your reply though

 

[tomcat]

This works well EXCEPT that my formula is too long for some of the links to
convert...even if I change the filenames to 1 letter...which is also
cumbersome. (mostily I am trying to keep this simple for customers to use)

 

[dalehohm]

How do I copy a formula from one workbook to another so that the pasted
formula does NOT have a link back to the copied workbook...... WITHOUT
redirecting/editing the Link?

This is an old post, but I found it when trying to do this...

In Excel 2013, Options, Advanced, Display Options For This Worksheet, Show Formulas In Cells Instead Of Their Calculated Results. Then you can copy and paste the formulas as plain text into Notepad and then copy and paste them into the other Excel worksheet.

Dale

 

[GS]

This is an old post, but I found it when trying to do this...

In Excel 2013, Options, Advanced, Display Options For This Worksheet,
Show Formulas In Cells Instead Of Their Calculated Results. Then you
can copy and paste the formulas as plain text into Notepad and then
copy and paste them into the other Excel worksheet.

Dale

You can also NOT go through all that and just simply select the cell
(displays formula results), then select the formula displayed in the
Formula Bar to copy/paste elsewhere.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion