The easiest way is to use the following form for your hyperlinks:

=HYPERLINK("C:\temp\xwer.xls#Sheet2!B9","target")

The cell normally displays:
target
simply touch CNTRL-`
This will change the display to formula mode and you can see the
path/filename.
--
Gary''s Student - gsnu200736


"DMAnalyst" wrote:

I have a spreadsheet that links to other sheets and word documents. Does
anyone know of a quick way to change the view/display so that it would
display the actual pathname of the linked files rather than the name as I
have it now? Please advise.

Thank you in advance for your response.