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

Tools-->Options-->View-->Formulas

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