User wants to see full path in recent documents Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
 
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
 
Back
Top