Hi Robert

The way I see it you have three options. You can paste the values,
though you would have already thought of that. If your two worksheets
are identical you could paste it across and find the references in a
block something like

Find '[Book1.xls]Sheet1'!

Replace with nothing in the replace box

This will remove all of the references to the first workbook.

Finally you could break the links though this has the same result as
the first option in that it hard codes everything. Anyways just some
suggestions.

Take care

Marcus