 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Links / May 2006Removing/Resolving Links before Copy
Excel 2003. I have workbooks in which there are internal links (cell references and references to labeled cells). I would like to "freeze" these before copying these sheets to another workbook. How can I resolve the internal links or references so that the references are no longer there, only the actual values the references produce? Thanks for the help and God bless.  SignatureDr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org Select the cells Edit / Copy Edit / Paste Special / Values To avoid losing the formulas from your master copy you might do better to copy the sheets and then replace the formulas in the new copy. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.