See my reply to Peo. Clearly I did not word the original question well. I
think the issue is this is a macro and I am not a macro expert (understand
but don't use extensively)
--
Doug T


"Gord Dibben" wrote:

Select the formula cells in source sheet and EditReplace

What: =

With: ^^^

Replace all.

Copy to target worksheet and reverse the EditReplace on both sheets.


Gord Dibben MS Excel MVP

On Thu, 4 Oct 2007 07:20:01 -0700, Doug T
wrote:

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?