Sorry, unable to find xxxxxxxxxxxxxxxxxxxxx\filename.xlsx

I have tried opening the same file, located on my laptop, using several different methods....

Double-clicking, Open with, dragging it into an open version of Excel, accessing directly using file->open from within Excel.

Each time, I receive the following dialog
Sorry, we couldn't find C:\Users\bschwendenman\Documents\Infor ERP XA\Infor ERP XA Localizations\Notes and Drafts\Release 9\Incoming (from TwinGroup)\SP1 - ERPXA 46083 and 46085\For distribution\PDC_XAR9_M9M_ServerL10N_ESPFRA_SP1_SH94091690_Vol1_of_1.xlsx.  Is it possible it was moved, renamed or deleted?

Given I tried opening it by double-clicking on the document itself and by dragging to an open version of Excel, I highly doubt the object was moved in those nanoseconds.  I suspect that the issue has to do with the combined length of the path and document name, but I can find nothing referencing any limitation in either nor any issues reported that relate to this.

Also given that Excel and Windows 7 allowed me to save this file to this specific location in the first place, I wonder why I can save it to this location but not open it from the location.

I'm sure that I can simply drag the file to the desktop, open and edit it and then drag it back and replace the existing document, but in this day of long file and folder names, cloud drivers, etc., it would seem that this type of limitation would be short sighted.

Is it actually a path/file name length error?  And if so, why not state that in the message...at least as a possibility?

Thanks
bruce
 

Question Info


Last updated January 17, 2019 Views 78,407 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

           
 C:\Users\bschwendenman\Documents\Infor ERP XA\Infor ERP XA Localizations\Notes and Drafts\Release 9\Incoming (from TwinGroup)\SP1 - ERPXA 46083 and 46085\For distribution\PDC_XAR9_M9M_ServerL10N_ESPFRA_SP1_SH94091690_Vol1_of_1.xlsx.  Is it possible it was moved, renamed or deleted?.
 
Is it actually a path/file name length error?  And if so, why not state that in the message...at least as a possibility?
The path length is 231 characters and Windows will handle up to 260 characters for a path, so no, it is not a text length error. I have seen that error message before on my system though and each time it is because that path no longer contains the indicated file. Can you click your way down that path in Windows Explorer and actually see that file?
*** PLEASE READ ***

If this response answers your question, please mark it as the "Answer".

65 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I have the same problem, and have similarly tried various options for selecting the file. I've also tried renaming the file. If Rick Rothstein is a MVP - Excel then I'm surprised he hasn't encountered this. I encountered it after 2 hours of using Excel 2013.

9 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I found a workaround for this Excel 2013 bug.

Move the file to another folder and then try opening it (it opens). This seems to update whatever cache Excel seems to be using to presume to know where the file lived.

319 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

"If Rick Rothstein is a MVP - Excel then I'm surprised he hasn't encountered this. I encountered it after 2 hours of using Excel 2013"
I doubt that Rick would ever work with such complex folder names!

Please be assured his knowledge of Excel exceeds yours by a vast amount.

http://people.stfx.ca/bliengme
A Guide to MS Excel 2013 for Scientists and Engineers

9 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Just in case anyone reads this old thread ... the length limit in Excel for path names is 218 characters.

 

support.microsoft.com/kb/213983

 

36 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

LMBR SAP BW P2P and AP Reporting Matrix for July Go-Live V0.4 Solution Proposal.xlsx

This is my file name and its no where nere to be 200, but i experience the same problem

4 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

That's just your FILE name. The full PATH name - drive, folders, filename, cannot exceed 218 chars.

17 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

i had the same problem.i found out that the problem had come up throgh the Add-Ins.you probably have installed a add-Ins and after that the file maybe  has been deleted.

1.go to Add_Ins

2.find the PDC_XAR9_M9M_ServerL10N_ESPFRA_SP1_SH94091690_Vol1_of_1.xlsx

3.select it and press the GO in the botom of the window

4.remove the check mark of the PDC_XAR9_M9M ....

5. ok

116 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

This works for me, just to provide more info, you have to right click on the toolbar to select "Customize the Ribbon" then tick "Developer" then "Add-Ins" to remove the file. I'm using excel 2013 and problem solved.

38 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Is there any way to vote for this bug to be fixed? It is still there 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. This thread alone has over 11 thousand views.

12 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.