+ Reply to Thread
Results 1 to 6 of 6

UNC Path length problem opening a file in excel 2002 or 2003

  1. #1
    John
    Guest

    UNC Path length problem opening a file in excel 2002 or 2003

    I've had several of my users that can't open an excel file when the UNC path
    length gets close to 220 characters. The UNC points to a 2003 server. This
    happens if you try to open using windows explorer or using the OPEN command
    in excel.

    Only excel is giving us problems. Word and other programs work just fine.

    I can't find anything in the knowledge base. Has anyone else seen this
    problem?

    Thanks
    John

    P.S. Please CC to j w a r r e n _ r e m o v e (a t ) p r u d e n t r x
    _ r e m o v e . c o m

    Take out the "_ r e m o v e" from the address.

  2. #2
    RWN
    Guest

    Re: UNC Path length problem opening a file in excel 2002 or 2003

    From Excel Help "Guidelines for naming Files" (xl2k)
    To make it easier to find your workbooks, you can use long, descriptive file names. The
    complete path to the file, including drive letter, server name, folder path, file name,
    and a three-character file name extension, can contain up to 218 characters. File names
    cannot include

    --
    Regards;
    Rob
    ------------------------------------------------------------------------
    "John" <[email protected]> wrote in message
    news:[email protected]...
    > I've had several of my users that can't open an excel file when the UNC path
    > length gets close to 220 characters. The UNC points to a 2003 server. This
    > happens if you try to open using windows explorer or using the OPEN command
    > in excel.
    >
    > Only excel is giving us problems. Word and other programs work just fine.
    >
    > I can't find anything in the knowledge base. Has anyone else seen this
    > problem?
    >
    > Thanks
    > John
    >
    > P.S. Please CC to j w a r r e n _ r e m o v e (a t ) p r u d e n t r x
    > _ r e m o v e . c o m
    >
    > Take out the "_ r e m o v e" from the address.




  3. #3
    John
    Guest

    Re: UNC Path length problem opening a file in excel 2002 or 2003

    Missed that although the word and windows have a limit of 256. I wonder why
    Excel is shorter.

    Thanks
    John


    "RWN" wrote:

    > From Excel Help "Guidelines for naming Files" (xl2k)
    > To make it easier to find your workbooks, you can use long, descriptive file names. The
    > complete path to the file, including drive letter, server name, folder path, file name,
    > and a three-character file name extension, can contain up to 218 characters. File names
    > cannot include
    >
    > --
    > Regards;
    > Rob
    > ------------------------------------------------------------------------
    > "John" <[email protected]> wrote in message
    > news:[email protected]...
    > > I've had several of my users that can't open an excel file when the UNC path
    > > length gets close to 220 characters. The UNC points to a 2003 server. This
    > > happens if you try to open using windows explorer or using the OPEN command
    > > in excel.
    > >
    > > Only excel is giving us problems. Word and other programs work just fine.
    > >
    > > I can't find anything in the knowledge base. Has anyone else seen this
    > > problem?
    > >
    > > Thanks
    > > John
    > >
    > > P.S. Please CC to j w a r r e n _ r e m o v e (a t ) p r u d e n t r x
    > > _ r e m o v e . c o m
    > >
    > > Take out the "_ r e m o v e" from the address.

    >
    >
    >


  4. #4
    RWN
    Guest

    Re: UNC Path length problem opening a file in excel 2002 or 2003

    Just to bring some mental stimulation to the whole process(?).

    --
    Regards;
    Rob
    ------------------------------------------------------------------------
    "John" <[email protected]> wrote in message
    news:[email protected]...
    > Missed that although the word and windows have a limit of 256. I wonder why
    > Excel is shorter.
    >
    > Thanks
    > John
    >
    >
    > "RWN" wrote:
    >
    > > From Excel Help "Guidelines for naming Files" (xl2k)
    > > To make it easier to find your workbooks, you can use long, descriptive file names.

    The
    > > complete path to the file, including drive letter, server name, folder path, file

    name,
    > > and a three-character file name extension, can contain up to 218 characters. File

    names
    > > cannot include
    > >
    > > --
    > > Regards;
    > > Rob
    > > ------------------------------------------------------------------------
    > > "John" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > I've had several of my users that can't open an excel file when the UNC path
    > > > length gets close to 220 characters. The UNC points to a 2003 server. This
    > > > happens if you try to open using windows explorer or using the OPEN command
    > > > in excel.
    > > >
    > > > Only excel is giving us problems. Word and other programs work just fine.
    > > >
    > > > I can't find anything in the knowledge base. Has anyone else seen this
    > > > problem?
    > > >
    > > > Thanks
    > > > John
    > > >
    > > > P.S. Please CC to j w a r r e n _ r e m o v e (a t ) p r u d e n t r x
    > > > _ r e m o v e . c o m
    > > >
    > > > Take out the "_ r e m o v e" from the address.

    > >
    > >
    > >




  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: UNC Path length problem opening a file in excel 2002 or 2003

    Anthony, this thread is almost 9 years old, I doubt anyone is still following it
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Registered User
    Join Date
    08-07-2014
    Location
    Sri Lanka
    MS-Off Ver
    2007
    Posts
    1

    Re: UNC Path length problem opening a file in excel 2002 or 2003

    Try LONG PATH TOOL!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1