Thread: How do I copy formulas from one wkb to another w/out linkng them?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] richey.david.j@gmail.com is offline
external usenet poster
  
Posts: 2
Default How do I copy formulas from one wkb to another w/out linkng them?
On Thursday, July 7, 2005 at 12:21:22 PM UTC-7, 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 may not completely apply. I wanted to reveal the formulas in another worksheet as part of a presentation of how the data is managed. I copied the cells to a fresh worksheet (so as not to loose the functional data) using the paste special--formulas, and then revealed the formulas (cntrl + ~). I then searched and replaced "+" with ""). formulas revealed and copy-able to anther worksheet.

--David
Reply With QuoteReply With Quote