Results 1 to 3 of 3

Thread: vlookup links

  1. #1
    slb
    Guest

    vlookup links

    I created a destination spreadsheet with links to a source workbook through the vlookup formula. I've found however that if changes have been made in the source file and the destination file is then updated, you can't selectively choose which places are updated and which are not. Unless someone has a solution as to how to only update certain worksheets in the destination workbook, I would like to "break" the links. I've tried replacing the formulas with hard data but the file still retains the links and asks if I want them updated when I open it.

  2. #2
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vlookup links

    If you are using Excel 97 there is a download you can get from Microsoft called the Delete Links Wizard. It deletes six different kinds of links. I used it on a spreadsheet that at one time had charts linked to data in various locations. Even after the charts were deleted, the links remained. The Delete Links Wizard found many hidden links and took care of the problem.

    Here is the Knowledge Base Article number: Q188449
    You can also find it at the Download Center: http://www.microsoft.com/downloads
    egghead

  3. #3
    slb
    Guest

    Re: vlookup links

    Thanks. I found another thread that referred to the Delete Links Wizard after my initial post and decided to try it even though I'm running Excel 2000. So far, it seems to have worked. Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •