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).
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).
Hi
Show formulas if any formula shows a sheet name first its linked.
Chris
Click my star if I helped Thanks
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
Sixthsense Alt+E+K leads to "find and replace"
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.
Sixthsense i like to know my active worksheet is linked to any other worksheet
Press Ctrl+F to get the Find and Replace and in Find whatand Click Find AllFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks