LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MDW MDW is offline
external usenet poster
 
Posts: 117
Default 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!




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum length of a number Pé Excel Worksheet Functions 1 October 31st 06 11:42 AM
UNC Path length problem opening a file in excel 2002 or 2003 John Excel Discussion (Misc queries) 3 October 14th 05 03:43 AM
what is maximum row length in excel dlb1228 Excel Discussion (Misc queries) 2 August 10th 05 02:13 PM
Path\File name length problem Excel Crash on save as Datasort Excel Discussion (Misc queries) 0 April 8th 05 05:19 PM
maximum formula length skywalker99 Excel Worksheet Functions 2 March 1st 05 09:30 PM


All times are GMT +1. The time now is 01:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"