Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Subfolder Level Limitations

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
netrangerx@gmail.com - 08 Jan 2008 20:55 GMT
Is there a limit to the number of levels deep an Excel (or Office)
file can be? I have a user who can not open Excel files from a file
server if that file is 7 levels deep. The file still does not open at
the 6th level, but DOES open at the 5th. A PDF file at 7 levels deep
opens fine, suggesting it is a limitation of Excel or Office, but
wanted to know for sure.

Thanks.
Bernard Liengme - 08 Jan 2008 21:46 GMT
Could be that the string for the path is getting too long
Maybe Acrobat using longer strings
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Is there a limit to the number of levels deep an Excel (or Office)
> file can be? I have a user who can not open Excel files from a file
[quoted text clipped - 4 lines]
>
> Thanks.
Gord Dibben - 08 Jan 2008 21:47 GMT
I believe you will find it is not a level limitation but a character limit on
the pathname length.

http://support.microsoft.com/kb/213983/en-us

Gord Dibben  MS Excel MVP

>Is there a limit to the number of levels deep an Excel (or Office)
>file can be? I have a user who can not open Excel files from a file
[quoted text clipped - 4 lines]
>
>Thanks.
netrangerx@gmail.com - 11 Jan 2008 16:57 GMT
> I believe you will find it is not a level limitation but a character limit on
> the pathname length.
[quoted text clipped - 13 lines]
>
> - Show quoted text -

Thank you all for your replies. The MS bulletin answered my question.
Thanks again.

Regards.
Harlan Grove - 08 Jan 2008 21:51 GMT
netrang...@gmail.com wrote...
>Is there a limit to the number of levels deep an Excel (or Office)
>file can be? I have a user who can not open Excel files from a file
>server if that file is 7 levels deep. The file still does not open at
>the 6th level, but DOES open at the 5th. A PDF file at 7 levels deep
>opens fine, suggesting it is a limitation of Excel or Office, but
>wanted to know for sure.

First question would be what's the server OS?

FWIW, on a Windows 2003 server share mapped as F: I just saved, closed
and reopened a file with the pathname

F:\a\b\c\d\e\f\g\h\i\j\k\l\m\n\o\p\deleteme.xls

so 16 subdirectory levels deep.

I'm not aware of any restriction on directory level nesting per se,
but there are OS restrictions on the length of fully qualified
pathnames. How many characters does this user's fully qualified
pathname have?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.