In MS Office 2007,I unable to find an option for viewing the path of current
file.

In MS Office 2003, there will be option called "Web" which show the complete
path of the current Excel sheet.
Like wise I need to know the option in MS office 2007

You can still use this technique

http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sivagami" wrote in message
...
In MS Office 2007,I unable to find an option for viewing the path of
current
file.

In MS Office 2003, there will be option called "Web" which show the
complete
path of the current Excel sheet.
Like wise I need to know the option in MS office 2007

In an un-used cell, enter:

=CELL("filename",A1)


this will display something like:

C:\Documents and Settings\Owner\Desktop\[builder.xls]Sheet2

which displays pathname, filename and sheetname.
--
Gary''s Student - gsnu200798


"Sivagami" wrote:

In MS Office 2007,I unable to find an option for viewing the path of current
file.

In MS Office 2003, there will be option called "Web" which show the complete
path of the current Excel sheet.
Like wise I need to know the option in MS office 2007