+ Reply to Thread
Results 1 to 7 of 7

How to find out if a worksheet is linked to any other worksheet

  1. #1
    Registered User
    Join Date
    11-23-2012
    Location
    Maldives
    MS-Off Ver
    Excel 2007
    Posts
    24

    How to find out if a worksheet is linked to any other worksheet

    I like to know the easiest way of finding out if any cell(s) of a worksheet is linked to any other worksheet(s), or workbook(s).

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: How to find out if a worksheet is linked to any other worksheet

    Hi

    Show formulas if any formula shows a sheet name first its linked.

    Chris
    Click my star if I helped Thanks

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How to find out if a worksheet is linked to any other worksheet

    About Tracing of External workbook Linking Press Alt+E+K


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Registered User
    Join Date
    11-23-2012
    Location
    Maldives
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: How to find out if a worksheet is linked to any other worksheet

    Sixthsense Alt+E+K leads to "find and replace"

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How to find out if a worksheet is linked to any other worksheet

    No I believe it won't.

    If your active worksheet is having a linked formula to external workbook then surely hitting Alt+E+K will get the Edit Links Dialog box.

  6. #6
    Registered User
    Join Date
    11-23-2012
    Location
    Maldives
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: How to find out if a worksheet is linked to any other worksheet

    Sixthsense i like to know my active worksheet is linked to any other worksheet

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How to find out if a worksheet is linked to any other worksheet

    Press Ctrl+F to get the Find and Replace and in Find what
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and Click Find All

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1