Increase the 218 character filename length limit to open files in excel
Excel can't open files with full path lengths greater than 218 characters as documented in https://support.microsoft.com/en-us/kb/213983. This is still a problem in Office 2016. It seems crazy that Excel can't open a valid file that the filesystem allows. People have been complaining about this since Office 2000. The thread below has over 11 thousand views and there are plenty others. Please fix this. http://answers.microsoft.com/en-us/office/forum/office2013release-excel/sorry-unable-to-find/595333d0-1463-499f-967e-4da8ac2e2047
Thank you for your continued feedback! We are happy to let you know that the work to enable this feature has started. We’ll share more details as we make progress.
David [Microsoft Excel Team]
Steve Schulte commented
Please hurry-up and get this fixed! I have a file nested 10 folders deep on my Mac and cannot open it without moving it to a higher level. Thanks!
That's great. Microsoft does not fix the old bugs/limitations, but introduces new ones with each generation. Sometimes I really bang my head if I try to do somthing that worked in the previous version, but I just can't make it work in the latest one. And then at times I stumble about things like a filepath limitiation, or other bugs/limitations that survived for decades.
Furthermore, this tells that exel is mixing code from various technolgies/libraries (seems to still have MFC parts and I wouldn't be surprised about some code from 16bit version). Which might be one reason for limited stability.
With 215 comments already it's clear MS is not interested once they've sold you the lemon.
Not looking for it, no, but thanks, of course.
Excel still fleshes it back to out to its complete and utter formal pathway so it won't solve the length it adds to a formula issue here. Sadly, since it's such an easy fix. Been using that approach literally since hard drives were still too expensive to buy. Sigh... I remember that first 2 MB hard drive fondly... And still hate Radio Shack for selling me a 40 MB hard drive but selling it as a 32 MB hard drive and me never suspecting they did that for about three years. And I bet some of them still wonder how they went out of business. At least IBM simply sold you the lesser equipment for a higher amount. Sucky, but not dishonest. Ahhh... memory lane... the place this stupid limitation belongs! Memory Lane... seems to lead to Memory Avenue to Memory Court to... now I see how old folk get confused... stupid limitation!
Stuart Bailie commented
If you are looking for an actual work around that works use the shell command SUBST.
SUBST R: C:\Users\UserName\Documents\Path\Of\Stupidly\long\documents\folder\because\we\cannot\shorten\it\for\some\unholy\reason\probably\because\of\karen\in\accounting\
Now when you reference R:\ it will be the full path name for the C: but applications don't see the redirect reference. I don't think this command is permanent so it will need to be repeated every time the user logs in.
The annoying part that I find in the save file length is that it was never reconsidered as an issue when:
1) NTFS allowed for path names longer than 256 characters
2) SharePoint became a driving force
3) OneDrive for Business became an option
4) Office 365's major push was done
As far as I'm concerned that puts the but to be older than 10 years but no one at Microsoft thought it was worth fixing or putting on a project plan for a better solution.
That will work if there are not external references to resolve that lead to the "correct" file location (rather than the saving before moving location) AND you do not need to build references to its contents in other files.
First kind might be related files located together with it. If referencing the right location in the formulas involving them, you'll exceed Excel's ability to resolve them as they are the things that exceed the 218 character limit. Not actually the path to the location, directly, but rather its length's effect on formulas referencing it and other things in a path that leads to the reference exceeding the limit.
Second kind of failure, even though the trick worked to save this file and relocate it, would be other files then referencing it using that path and thereby themselves exceeding the 218 character limit for a reference in a formula.
Depending upon how you or others involved handle errors returned by the applicable formulas, you might never notice errors while building them as the error handling catches this along with others leading you to not think anything new and unique has happened.
But when you go to save that file...
Sad, sad situation really. Can't even alias a location as "drive Q" or what-have-you as Excel still resolves it fully and dings you for the length.
Maybe someday, b*ttm*nch programmers and/or their bosses will stop saying "who would ever want more than that..."
Tom Adams commented
extra work but seems to work by saving the file in a top-level folder (shorter path) with the complete file name and then move the closed excel file into the sub-folder where it belongs.
cannot believe.. In 2019 this is still an issue. With NTFS filesystem and computers with 8-16-32..etc Gb memory. They focusing on annoying useless features like "Ideas" in Excel..etc. But really important problems are not fixed.
Only excel have been limited to 218 characters, other files are 260 character limit i believe hence why the pdf files work fine for you. Glad to see they have finally started working on it. We hope we don't wait another year or 2 before rolled out.
To add to this; I have found that I can save pdf files which go beyond the 218 limit but not the exact same excel file name! As an example: I receive pdf files which I save to a certain folder, and I create an excel file to instruct our Accounts Payable team to pay the invoice on the received PDF. So that I can match the invoice to the payment instruction I save them with the exact same name but the corresponding extension, but the Excel file won't save because it is 10 characters over the limit and I have to truncate it!
Very frustrating and surely there's no good reason for it in this day and age.
Please for the love of god fix this!
It would also be helpful to release a work around ?🙏
Stuart Bailie commented
David thanks for the update. Is there a loose guess to a time line? Can we see the feature in O365 Office next quarter? Next year?
Gerald Platzer commented
Still a big issue for our user community. This has to be resolved ASAP.
Gerald Platzer commented
Still a big users for my user community. This has to be resolved ASAP.
Still not listed in the 365 Roadmap - could this please be added so it can be acknowledged formally?
This is really an annoying issue - to open files with long paths I have to move them to my workspace, and then when I am done I have to move them back again. Is is incredible that this issue is still not solved.
Justin Mosebach commented
Seriously, what is this... 1993?
I need to keep my files in folders order arranged as I am working in a project with multiple countries.
This is not agreeable that only 218 characters is agreed in such situation.
Afruja Aktar Mili commented
Please help to increase characters from 218 characters of Office 2016. It's crazy! If you already worked on it, please suggest the possible way. Thanks