General discussion

  • Creator
    Topic
  • #2081051

    Linking Workbooks in Excel

    Locked

    by nk ·

    How do you unlink workbooks? I know that there is a links option in the Edit menu but that only allows you to update the link. It does not allow you to remove the link.

All Comments

  • Author
    Replies
    • #3785319

      Linking Workbooks in Excel

      by dklippert ·

      In reply to Linking Workbooks in Excel

      You’ll have to locate the formulas that are referencing the other spreadsheet and remove the reference. The workbook will then stop asking for update information.

      • #3785317

        Linking Workbooks in Excel

        by nk ·

        In reply to Linking Workbooks in Excel

        How do you located the formulas referencing the other spreadsheet?

    • #3785242

      Linking Workbooks in Excel

      by dklippert ·

      In reply to Linking Workbooks in Excel

      There are a couple of ways, depending on the size of your spreadsheet.
      1) touch F5 (GoTo). Choose Special and Formulas. All of the formulas on that sheet will be highlighted and you can Tab through them to locate the relevant entries.
      2)Ctrl+~ (Control+ tilde) will toggle all formulas to be displayed.
      3) Use Edit>Find to locate something like: !, .xls, [ or other components of a formula that indicate links.

    • #3742822

      Linking Workbooks in Excel

      by nk ·

      In reply to Linking Workbooks in Excel

      This question was closed by the author

Viewing 2 reply threads