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.

In Excel 2007, you can display the full file path and name of the active file by customizing the Quick Access Toolbar. Here are the steps:

1. Click on the Office button in the top left corner of the Excel window.
2. Click on Excel Options at the bottom of the menu.
3. Click on Customize in the left-hand pane.
4. In the Choose commands from drop-down menu, select All Commands.
5. Scroll down and select Document Location from the list of commands.
6. Click on the Add button to add the command to the Quick Access Toolbar.
7. Click OK to close the Excel Options window.

Now, the full file path and name of the active file will be displayed in the Quick Access Toolbar. If you want to move the toolbar to a different location, you can right-click on it and select Show Quick Access Toolbar Below/ Above the Ribbon.

You could add the Document Location control from the All Commands group to
the QAT as described he

http://office.microsoft.com/en-us/ex...659011033.aspx

--
Jim
"Gary Roll" wrote in message
...
| 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.