If it is just a single cell copy from the formula bar, if there are many
replace = with ^=^ get all formulas converted to text strings, copy and
paste then reverse the replace in both workbooks
and replace ^=^ with =


--


Regards,


Peo Sjoblom



"Doug T" wrote in message
...
I am trying to copy a workbook from one worksheet to another. The workbook
contains cells with input ranges referencing a workbook within the
original
worksheet. When I copy or move to the second worksheet the Input Range
formula changes
from
'Valid Values'!$W$1:$W$3
to
'[OriginalWorksheetName.xls]Valid Values'!$W$1:$W$3

obviously referencing the original spreadsheet. Is there a way for this
to
copy in a non relative way?
--
Doug T