| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding File location in a given cell
I am trying to add the file location in a cell. I know how to add to the
header and footer, but am unable to locate a function/formula to put in a given cell. I want this to change if the file moves locations so the user does not have to update the cell. I am using Excel 2003, Office Proffessional Edition 2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding File location in a given cell
=CELL("Filename",A1)
-- Regards, Peo Sjoblom "Debra" wrote in message ... I am trying to add the file location in a cell. I know how to add to the header and footer, but am unable to locate a function/formula to put in a given cell. I want this to change if the file moves locations so the user does not have to update the cell. I am using Excel 2003, Office Proffessional Edition 2003. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding File location in a given cell
Thank you, That is exactly what I was looking for.
"Peo Sjoblom" wrote: =CELL("Filename",A1) -- Regards, Peo Sjoblom "Debra" wrote in message ... I am trying to add the file location in a cell. I know how to add to the header and footer, but am unable to locate a function/formula to put in a given cell. I want this to change if the file moves locations so the user does not have to update the cell. I am using Excel 2003, Office Proffessional Edition 2003. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding File location in a given cell
Thanks for the feedback
-- Regards, Peo Sjoblom "Debra" wrote in message ... Thank you, That is exactly what I was looking for. "Peo Sjoblom" wrote: =CELL("Filename",A1) -- Regards, Peo Sjoblom "Debra" wrote in message ... I am trying to add the file location in a cell. I know how to add to the header and footer, but am unable to locate a function/formula to put in a given cell. I want this to change if the file moves locations so the user does not have to update the cell. I am using Excel 2003, Office Proffessional Edition 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 - How to find cell location of a link to another file? | Excel Discussion (Misc queries) | |||
| file location | Excel Discussion (Misc queries) | |||
| Get File location | Excel Discussion (Misc queries) | |||
| Vlookup file location changes depending on value within cell | Excel Worksheet Functions | |||
| Location of XLB file? | Excel Discussion (Misc queries) | |||
Linear Mode
