Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect does not recognize full server path?
I have an excel workbook linked to several other workbooks (all of which
change names - i.e. a date indexing: filename_date.xls). They also live on different servers, so I am trying to set the full server names \\server\folder\etc. If I use the defined path, i.e. W:\, indirect works, but when I change the the W:\ to \\server\folder, it doesn't - I get #REF! I need to use the full server path becuase the file will be shared among others who have different paths set up Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect does not recognize full server path?
I think you'll find that with the next calculation, that =indirect() formula
that points at a closed workbook will fail--no matter how you refer to that path. Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed workbook. You can find the function at Harlan's FTP site: ftp://members.aol.com/hrlngrv/ Look for pull.zip Matt wrote: I have an excel workbook linked to several other workbooks (all of which change names - i.e. a date indexing: filename_date.xls). They also live on different servers, so I am trying to set the full server names \\server\folder\etc. If I use the defined path, i.e. W:\, indirect works, but when I change the the W:\ to \\server\folder, it doesn't - I get #REF! I need to use the full server path becuase the file will be shared among others who have different paths set up Thanks! -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect does not recognize full server path?
I have the files open, and it fails using the full server path, but not when
I use the defined path (and the file open, of course)... "Dave Peterson" wrote: I think you'll find that with the next calculation, that =indirect() formula that points at a closed workbook will fail--no matter how you refer to that path. Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed workbook. You can find the function at Harlan's FTP site: ftp://members.aol.com/hrlngrv/ Look for pull.zip Matt wrote: I have an excel workbook linked to several other workbooks (all of which change names - i.e. a date indexing: filename_date.xls). They also live on different servers, so I am trying to set the full server names \\server\folder\etc. If I use the defined path, i.e. W:\, indirect works, but when I change the the W:\ to \\server\folder, it doesn't - I get #REF! I need to use the full server path becuase the file will be shared among others who have different paths set up Thanks! -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect does not recognize full server path?
If the file is open, you don't need the path at all.
I'd remove the path from the formula. I don't have a network to test it on, but I don't recall seeing any length restriction for that path. There is a length restriction for a formula in excel, though. It can't exceed 1024 characters when measured in R1C1 reference style. Any chance that's the problem? Matt wrote: I have the files open, and it fails using the full server path, but not when I use the defined path (and the file open, of course)... "Dave Peterson" wrote: I think you'll find that with the next calculation, that =indirect() formula that points at a closed workbook will fail--no matter how you refer to that path. Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed workbook. You can find the function at Harlan's FTP site: ftp://members.aol.com/hrlngrv/ Look for pull.zip Matt wrote: I have an excel workbook linked to several other workbooks (all of which change names - i.e. a date indexing: filename_date.xls). They also live on different servers, so I am trying to set the full server names \\server\folder\etc. If I use the defined path, i.e. W:\, indirect works, but when I change the the W:\ to \\server\folder, it doesn't - I get #REF! I need to use the full server path becuase the file will be shared among others who have different paths set up Thanks! -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
full UNC path in footer | Excel Discussion (Misc queries) | |||
full path of excel file | Excel Discussion (Misc queries) | |||
Drive and full path in name at top of screen | Excel Discussion (Misc queries) | |||
Recurring Problems with Links with Full Path Names | Excel Discussion (Misc queries) | |||
How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) |