Maximum Length For Linked Workbook Path?
 

I've got a co-worker trying to update links (by changing the linked workbook)
in an Excel 2003 workbook. Whenever she selects the file she wants to link
to, Excel goes to "Not responding" status and she has to shut it down via
Task Manager.

We can get around the problem by moving the desired file into a folder with
a much shorter name (we use folder names like
"May_03_Test_Version_2_With_Updated_Assumption s"). Is there a length limit to
folder/path names you can have on linked workbooks? I've never seen something
like this before.

TIA
--
Hmm...they have the Internet on COMPUTERS now!

Maximum Length For Linked Workbook Path?
 

We have a user within our company that has a tendency of giving various
files long names. Without going through a standard procedure, which I use
for some of the stuff that I process for the company, it would exceed the
214 character length limit for the full file path spec name, thus we had to
use naming conventions to limit that impact greatly.

Note: File path spec name includes the server name or drive letter, the
path name to it, and the file name including the 3 letter extension ("xls"
in this case) at the end of the file.

Ronald R. Dodge, Jr.
Master MOUS 2000

"MDW" wrote in message
...
I've got a co-worker trying to update links (by changing the linked
workbook)
in an Excel 2003 workbook. Whenever she selects the file she wants to link
to, Excel goes to "Not responding" status and she has to shut it down via
Task Manager.

We can get around the problem by moving the desired file into a folder
with
a much shorter name (we use folder names like
"May_03_Test_Version_2_With_Updated_Assumption s"). Is there a length limit
to
folder/path names you can have on linked workbooks? I've never seen
something
like this before.

TIA
--
Hmm...they have the Internet on COMPUTERS now!

Maximum Length For Linked Workbook Path?
 

In this case, the total file name + path were about 150 characters.

--
Hmm...they have the Internet on COMPUTERS now!


"Ronald Dodge" wrote:

We have a user within our company that has a tendency of giving various
files long names. Without going through a standard procedure, which I use
for some of the stuff that I process for the company, it would exceed the
214 character length limit for the full file path spec name, thus we had to
use naming conventions to limit that impact greatly.

Note: File path spec name includes the server name or drive letter, the
path name to it, and the file name including the 3 letter extension ("xls"
in this case) at the end of the file.

Ronald R. Dodge, Jr.
Master MOUS 2000

"MDW" wrote in message
...
I've got a co-worker trying to update links (by changing the linked
workbook)
in an Excel 2003 workbook. Whenever she selects the file she wants to link
to, Excel goes to "Not responding" status and she has to shut it down via
Task Manager.

We can get around the problem by moving the desired file into a folder
with
a much shorter name (we use folder names like
"May_03_Test_Version_2_With_Updated_Assumption s"). Is there a length limit
to
folder/path names you can have on linked workbooks? I've never seen
something
like this before.

TIA
--
Hmm...they have the Internet on COMPUTERS now!