Determine Full Path of an Opened XL File

[Vince]

While having a workbook XL file opened, is there a way/menu selection
that will allow me to see the full file path (under Windows XPpro) ?
and possibly the date that the opened file was last revised?

I fear that I might have opened an outdated file and making data
revisions incorrectly.

Thanks.

Vince
Long Island, NY

 

[Jim Rech]

IF you display the Web toolbar it will show the full path to the active
workbook.

--
Jim
|
| While having a workbook XL file opened, is there a way/menu selection
| that will allow me to see the full file path (under Windows XPpro) ?
| and possibly the date that the opened file was last revised?
|
| I fear that I might have opened an outdated file and making data
| revisions incorrectly.
|
| Thanks.
|
| Vince
| Long Island, NY

 

[Dave Peterson]

Another way:

Find an empty cell and type this formula:
=cell("Filename",a1)

You'll see the drive, path, filename and sheet name like:
C:\My Documents\excel\[book1.xls]Sheet3

(The workbook has to be saved at least once, though.)

 

[Vince]

IF you display the Web toolbar it will show the full path to the active
workbook.

TnX Jim. I did not have the Web toolbar displayed.

 

[Vince]

TnX Dave. Your suggestion will work nicely for me.

Another way:

Find an empty cell and type this formula:
=cell("Filename",a1)

You'll see the drive, path, filename and sheet name like:
C:\My Documents\excel\[book1.xls]Sheet3

(The workbook has to be saved at least once, though.)

While having a workbook XL file opened, is there a way/menu selection
that will allow me to see the full file path (under Windows XPpro) ?
and possibly the date that the opened file was last revised?

I fear that I might have opened an outdated file and making data
revisions incorrectly.

Thanks.

Vince
Long Island, NY