Removing/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.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

Removing/Resolving Links before Copy
 

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