Reflect file path (show drive letters) in Excel 2000

[Alicia]

Hi,
If i am on a network environment and using excel 2000, i wish to reflect the
file location e.g. D:\project good\chart\book 2000.xls

How do i get excel 200 to generate the file location, other than having the
file name and sheet only?

 

[Jim Cone]

Hello Alicia,

Enter this formula, exactly as shown in a workbook that has been saved...
=CELL("filename")

Jim Cone
San Francisco, USA

 

[Alicia]

Jim, Thanks a lot!

Hello Alicia,

Enter this formula, exactly as shown in a workbook that has been saved...
=CELL("filename")

Jim Cone
San Francisco, USA

 

[Jason Morin]

In appears that this has been fixed for XL2002 and higher,
but older versions require the second argument (the
reference) when using =CELL("filename",A1). Read the
thread at:

http://tinyurl.com/57tpn

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello Alicia,

Enter this formula, exactly as shown in a workbook that has been saved...
=CELL("filename")

Jim Cone
San Francisco, USA

"Alicia" <[email protected]> wrote in

message [email protected]...

 

[Jim Cone]

Jason,
Thanks for the info.
Jim Cone

In appears that this has been fixed for XL2002 and higher,
but older versions require the second argument (the
reference) when using =CELL("filename",A1). Read the
thread at:
http://tinyurl.com/57tpn
HTH
Jason
Atlanta, GA