Viewing Links to source file

M

markstro

Is there a way to view just where the link to a source file is in a
destination workbook?
Markstro
 
A

Allan

I don't have an answer, but my problem is along the same
line. My new workbook has a link to an old workbook of
mine and I can't find where the link is or how to break it!

Allan
 
G

Gord Dibben

Mark and Allan

The link may not be in a cell.

Could be in a defined name.

Insert>Name>Define. Anything in there that is linked to another file?

Alternative......Download Bill Manville's FINDLINK.XLA from Stephen Bullen's
website.

http://www.bmsltd.ie/MVP/Default.htm

It is a ZIP file. You will need WinZip or similar to open and extract the
FINDLINK.XLA add-in.

Gord Dibben Excel MVP
 
D

David McRitchie

Allan,
I don't think your problem is at all related to Markstro's.
Yours is easily solved by downloading and using
FindLink by Bill Manville at http://www.bmsltd.ie/mvp

Hi Markstro,
What are you looking for. You have a link in a cell
there is no indicator at the object of the link that something
linked to it.

You can use the back and forward keys to return to where
you came from. (alt+ArrowLT and Alt+ArrowRT)
 
M

markstro

Thanks Dave, let me explain a little further.
When my wife and I open up our budget spreadsheet, (quite large) we
get the message prompting us if we want to update the links to another
sheet.
She cannot remember creating a link. We always say no to the update.
How do we identify the link to delete so we don't get the update
prompt anymore?

David McRitchie said:
Allan,
I don't think your problem is at all related to Markstro's.
Yours is easily solved by downloading and using
FindLink by Bill Manville at http://www.bmsltd.ie/mvp

Hi Markstro,
What are you looking for. You have a link in a cell
there is no indicator at the object of the link that something
linked to it.

You can use the back and forward keys to return to where
you came from. (alt+ArrowLT and Alt+ArrowRT)

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Allan said:
I don't have an answer, but my problem is along the same
line. My new workbook has a link to an old workbook of
mine and I can't find where the link is or how to break it!

Allan
Click to expand...
Click to expand...
 
D

Dave Peterson

The easiest thing to do is to download Bill Manville's Findlink addin.

It'll look all through your workbook trying to find links. When it finds them,
you can clean them up.

Visit that site and try it once.
Thanks Dave, let me explain a little further.
When my wife and I open up our budget spreadsheet, (quite large) we
get the message prompting us if we want to update the links to another
sheet.
She cannot remember creating a link. We always say no to the update.
How do we identify the link to delete so we don't get the update
prompt anymore?

David McRitchie said:
Allan,
I don't think your problem is at all related to Markstro's.
Yours is easily solved by downloading and using
FindLink by Bill Manville at http://www.bmsltd.ie/mvp

Hi Markstro,
What are you looking for. You have a link in a cell
there is no indicator at the object of the link that something
linked to it.

You can use the back and forward keys to return to where
you came from. (alt+ArrowLT and Alt+ArrowRT)

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Allan said:
I don't have an answer, but my problem is along the same
line. My new workbook has a link to an old workbook of
mine and I can't find where the link is or how to break it!

Allan
-----Original Message-----
Is there a way to view just where the link to a source file is in a
destination workbook?
Markstro
.
Click to expand...
Click to expand...
Click to expand...
 
Top