How to display full file path name in Excel 2007

[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.

 

[Jim Rech]

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.

 

[Surprise]

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