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