You're solution works well and updates as you do <File Save as which is
what I really need
Mervyn
"Dennis" wrote in message
...
Mervyn,

Something that I have used to document the location of W/S is:

In any cell, enter the formula =Cell("filename")
(Enter it exactly as above , in short, do not enter
the actual filename for "filename")

The above will display and print the drive; full path; and the Tab. Be
cautious though about the Tab, in most versions of XL the Pathe does not
update until a calculation is made.

Thus, if you open a W/B then a W/S and do not hit F9, the Tab displayed
may
be incorrect.


HTH Dennis

"Mervyn Thomas" wrote:

The default seems to be to show the filename on the top border in Excel.
Is
there any way to include the full path including the drive letter as
well?
I have an operator who gets confused as to where she is and this would be
really nice.