Restoring Links
 

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

Restoring Links
 

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