Internal/External Links

eggyjla

eggyjla

Active Member
Joined
Dec 16, 2004
Messages
346
I have a spreadsheet that contains external links to other workbooks. Using the [Edit][Links] I'm able to identify the link, however I am unable to locate that link within the workbook. What is/are the preferred methods for locating links within a workbook.
It might be nice if the Links window would state the cell that contains the link.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
I don't think there's a nice way to achieve this. Things to try would be to turn on the formula view in Options:View. This should help the links stand out. Alternatively try using Find on the link's name.

Jon C
 
Upvote 0
I've tried to search each worksheet looking for the source of the link and have not been successful. Any other ideas where the link might be referenced. I have also tried to Break Links, but the link still exists afterward.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Remove links to other documents, but text/number to remain
Replies
2
Views
311
Goddess
G
F
  • Question
Remove Specific email addresses from a long list of emails
Replies
3
Views
527
mumps
mumps
B
  • Question
How do I change the PivotTable data sourced by external connection to a table in the workbook?
Replies
0
Views
740
bigsim
B
spacecaptainsuperguy
  • Question
links not updating!
Replies
0
Views
554
spacecaptainsuperguy
spacecaptainsuperguy
H
  • Solved
External Link: cannot find it
Replies
2
Views
462
HankJ
H

Forum statistics

Threads
1,214,923
Messages
6,122,283
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top