User wants to see full path in recent documents Excel 2007

[Guest]

Is there any way to do this?

 

[Rick Rothstein \(MVP - VB\)]

Is there any way to do this?

On my system, hovering the cursor over the recent file name pops up a
tooltip showing the complete path. Does that happen for your user and, if
so, is that not sufficient?

Rick

 

[Guest]

Yes this does happen, She is just used to the old full path view in Excel
2002. If nothing can be done then oh well.
Thanks

 

[Rick Rothstein \(MVP - VB\)]

I'm not aware of any other way to see the full path, but then I am still
kind of new to XL2007 and could be missing something. I looked for some kind
of option before answering you and found nothing obvious, so it is possible
this is one of the "improvements" Microsoft made to XL2007.<g>

Rick

 

[David McRitchie]

See http://www.mvps.org/dmcritchie/excel/pathname.htm
for details and more choices

D:\driveM\excel\TAXES\[1996FEDT.XLS]Sheet1
=CELL("filename",A1)

D:\driveM\excel\TAXES\
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

doesn't make any difference what cell, as long as it is in the worksheet of interest.
Be sure to save the workbook