Maximum Length For Linked Workbook Path?

M

MDW

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_Assumptions"). Is there a length limit to
folder/path names you can have on linked workbooks? I've never seen something
like this before.

TIA
 
R

Ronald Dodge

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
 
Top