LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default how to view the path of current excel sheet?

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
View Custom View with Sheet Protection John H[_2_] New Users to Excel 1 February 16th 07 05:54 PM
Excel 2k3 query path to current directory busypgmr Excel Discussion (Misc queries) 1 September 5th 06 10:05 PM
Accessing current project path Dhonan Excel Discussion (Misc queries) 0 August 15th 06 10:03 PM
auto file path update when excel sheet moved to another directory. GNSBoy Excel Discussion (Misc queries) 1 August 31st 05 07:46 PM
How prevent formulas to get external references/path to current workbook? Gunnar Johansson Excel Worksheet Functions 1 August 15th 05 10:39 AM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"