In Edit=Links, select a link and change it to the new workbook (in other
words, it links to itself). This should cause the link(s) to be removed and
the formulas to point as you wish them to.

--
Regards,
Tom Ogilvy

"Adam" wrote in message
...
Hi All,

I have a spreadsheet which I have copied and moved some worksheets from
into
another workbook.

Problem is is that the worksheets I copied and moved contain links to the
first workbook. When I want them to look at the same links in the second
workbook.

Anyone know how I can get around this without manually correcting the
links?

Hope I've made sense !

--
Thanks

Adam

====================
Windows XP Pro + Office 2003 Pro