| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Reflect file path (show drive letters) in Excel 2000
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? |
|
#2
|
|||
|
|||
|
Hello Alicia,
Enter this formula, exactly as shown in a workbook that has been saved... =CELL("filename") Jim Cone San Francisco, USA "Alicia" wrote in message ... 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? |
|
#3
|
|||
|
|||
|
Jim, Thanks a lot!
"Jim Cone" wrote: Hello Alicia, Enter this formula, exactly as shown in a workbook that has been saved... =CELL("filename") Jim Cone San Francisco, USA "Alicia" wrote in message ... 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? |
|
#4
|
|||
|
|||
|
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" wrote in message news:64EB8582-FDFA-42E7-96B1- ... 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? . |
|
#5
|
|||
|
|||
|
Jason,
Thanks for the info. Jim Cone "Jason Morin" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| restrict opening Excel file residing on a shared drive to one user | Excel Discussion (Misc queries) | |||
| How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Linear Mode
