How to display full file path name in Excel 2007


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

Advertisements

J

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

Advertisements

Joined
Aug 20, 2012
Messages
1
Reaction score
0
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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top