Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Removing links to other spreadsheets (2000)

    Hi all,
    I am trying to help a co-worker with an Excel problem. His spread sheets have links to other spread sheets. He wants to remove the links to the other spread sheets without altering the rest of the workbook.
    Since this co-worker is an accountant, the workbooks are fairly large, thus I was hoping to hit the whole workbook or sheet at the same time rather than trying to hunt for the linked cells manually.

    I have tried to Copy and then Past Special (Formulas) but that leaves the links.
    Have also tried Copy and then Past Special (Values) but that deletes the formulas in the other cells if applied to the whole sheet.

    How can this be done?
    Thanks,
    Nemo

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Removing links to other spreadsheets (2000)

    See <!post=Post 101825,101825>Post 101825<!/post>; if necessary search for other related threads.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    New Lounger
    Join Date
    Nov 2001
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing links to other spreadsheets (2000)

    Thanks John,
    though I feel very foolish for not checking there first.

    Have a great day.

Posting Permissions

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