How to display full file path name in Excel 2007

  • Thread starter Thread starter Gary Roll
  • Start date Start date
G

Gary Roll

Excel 2003 has an option to display a Web toolbar that would show the entire
file path and name of the active file. I cannot find an equivalent function
in Excel 2007, can someone tell me how to accomplish that?

The same problem exists with Word 2007--I was able to get a macro that will
display the full file path in the doc title bar once the macro is added to
the Normal template. A similar solution for Excel would work, but I would
prefer to find an option that would automatically display the full file path
as the Web toolbar did.
 
You could add the Document Location control from the All Commands group to
the QAT as described here:

http://office.microsoft.com/en-us/excel/HA101659011033.aspx

--
Jim
| Excel 2003 has an option to display a Web toolbar that would show the
entire
| file path and name of the active file. I cannot find an equivalent
function
| in Excel 2007, can someone tell me how to accomplish that?
|
| The same problem exists with Word 2007--I was able to get a macro that
will
| display the full file path in the doc title bar once the macro is added to
| the Normal template. A similar solution for Excel would work, but I would
| prefer to find an option that would automatically display the full file
path
| as the Web toolbar did.
 
Go to Customise Quick Access Toolbar>More Commands
Choose Commands from: All Commands
Scroll down to Document Location and select Add>OK

Your full path and file name will now show either above or below the ribbon, depending on where you have set your Quick Access Toolbar to display
:cheers:
 
Back
Top