Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default User wants to see full path in recent documents Excel 2007

Is there any way to do this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,202
Default User wants to see full path in recent documents Excel 2007

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default User wants to see full path in recent documents Excel 2007

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)" wrote:

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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,202
Default User wants to see full path in recent documents Excel 2007

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


"wadeyk" wrote in message
...
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)" wrote:

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



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 903
Default User wants to see full path in recent documents Excel 2007

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

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"wadeyk" wrote in message ...
Is there any way to do this?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete Excel 2007 file from list under Recent Documents GPS Excel Discussion (Misc queries) 5 May 9th 23 11:47 AM
Excel 2007 add-ins in My Recent Documents BS LeBlanc Charts and Charting in Excel 1 August 30th 07 03:42 PM
Add-in files filling up My Recent Documents - Excel 2007 BS LeBlanc Excel Discussion (Misc queries) 1 August 29th 07 07:48 PM
How do I get Office 2007 to show me the full path of a file? rob653 New Users to Excel 2 March 28th 07 06:37 PM
Excel Documents Don't Appear in My Recent Documents Addi Excel Discussion (Misc queries) 4 July 24th 05 09:43 PM


All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"