Thread: How do I copy formulas from one wkb to another w/out linkng them?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dalehohm@gmail.com is offline
external usenet poster
  
Posts: 1
Default How do I copy formulas from one wkb to another w/out linkng them?
On Thursday, July 7, 2005 3:21:22 PM UTC-4, tomcat wrote:
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
Reply With QuoteReply With Quote