I would like to know if it's possible to "show links" that are in an existing
document. I want to show the user what links are embedded in the document.

Thanks!
.....Linda

Linda what do you mean by "show"? If you select Edit, Links, a list of the
linked workbooks appear.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Linda@LLBean" wrote in message
...
I would like to know if it's possible to "show links" that are in an
existing
document. I want to show the user what links are embedded in the
document.

Thanks!
....Linda

Tools--Options--View--Formulas

"Linda@LLBean" wrote:

I would like to know if it's possible to "show links" that are in an existing
document. I want to show the user what links are embedded in the document.

Thanks!
....Linda

I have a support/source worksheet that I would like to list what links are
used (and tell the user when to update/why the link is there). Most of my
link names include the date, so this is also an additional control for the
user.

The Edit/Link function only shows a partial name, not the full name (and I'd
have to instruct the user on how to do this).

The Tools/Options displays all links (will scare the heck out of my user!)
and again will truncate with the column width.

I was hoping to somehow create a formula that would show the text for the
referenced cell (ex: cell A1 on source document would be written as =
'summary page'A1 and would display the text in summaryA1 as
"C:server\path\link file.xls"

Thank you!
.....Linda




"Linda@LLBean" wrote:

I would like to know if it's possible to "show links" that are in an existing
document. I want to show the user what links are embedded in the document.

Thanks!
....Linda

Linda, take a look at the Link Finder at
http://www.add-ins.com/linkfind.htm. It can create a list of links for you.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Linda@LLBean" wrote in message
...
I have a support/source worksheet that I would like to list what links are
used (and tell the user when to update/why the link is there). Most of my
link names include the date, so this is also an additional control for the
user.

The Edit/Link function only shows a partial name, not the full name (and
I'd
have to instruct the user on how to do this).

The Tools/Options displays all links (will scare the heck out of my user!)
and again will truncate with the column width.

I was hoping to somehow create a formula that would show the text for the
referenced cell (ex: cell A1 on source document would be written as =
'summary page'A1 and would display the text in summaryA1 as
"C:server\path\link file.xls"

Thank you!
....Linda




"Linda@LLBean" wrote:

I would like to know if it's possible to "show links" that are in an
existing
document. I want to show the user what links are embedded in the
document.

Thanks!
....Linda

Perfect!

Thank you!
.....Linda

"Bob Flanagan" wrote:

Linda, take a look at the Link Finder at
http://www.add-ins.com/linkfind.htm. It can create a list of links for you.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Linda@LLBean" wrote in message
...
I have a support/source worksheet that I would like to list what links are
used (and tell the user when to update/why the link is there). Most of my
link names include the date, so this is also an additional control for the
user.

The Edit/Link function only shows a partial name, not the full name (and
I'd
have to instruct the user on how to do this).

The Tools/Options displays all links (will scare the heck out of my user!)
and again will truncate with the column width.

I was hoping to somehow create a formula that would show the text for the
referenced cell (ex: cell A1 on source document would be written as =
'summary page'A1 and would display the text in summaryA1 as
"C:server\path\link file.xls"

Thank you!
....Linda




"Linda@LLBean" wrote:

I would like to know if it's possible to "show links" that are in an
existing
document. I want to show the user what links are embedded in the
document.

Thanks!
....Linda