Restoring Links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Protection 2
VBA code for pasting links -- modifying RDB code for summary workbook 10
Exporting Sheets & Naming new workbook & Breaking links 1
How to enable "Links" when copy a worksheet (with buttons on it) to anew book 2
how to reshow userform after following a link 1
Copying cells and formula from closed workbook to all sheets in open workbook 0
Problems with incorrect linked values 5

Back
Top