Mar 07 2022 10:33 PM
This error is coming repeatedly even, I am clicking on Yes, and the file is corrupted. How do I repair my file? Is there any solution to recover my file?
Mar 07 2022 11:13 PM
Mar 08 2022 12:08 AM
Mar 22 2022 04:37 AM
Hello Adi,
I am glad to assist you; please try the below solutions to repair your file.
Solution 1: Change the default file format.
Try changing the Excel default file format by following these steps:
Check if you can open your Excel file. If not, try the next solution.
Solution 2: Edit the excel file permissions
Follow these steps to change the file permissions and see if it fixes the problem:
Now try to open the Excel file. If you are still getting the Excel file cannot open error, you can refer to the following thread and article:
Mar 22 2022 05:06 AM
Aug 09 2022 02:17 PM
@Adi_Star I'm actually having this error now that I have upgraded to the latest version of Office 2013. I have actually figured out that if I shorten the filename by 4 characters the error goes away. The strange thing is the path and file name are less than 100 characters so it can't be path limit. Office version 15.5459.1000 does not give the error and Office version 15.0.5475.1001 does give the error. If I move the file back one folder in the path it will open without the error but the path and filename are only about 85 characters total. Strange!
Aug 10 2022 12:09 AM - edited Aug 10 2022 12:10 AM
You are right! My Office version is 15.0.5475.1000 which gives the same error. Shorten the filename for more than 20 characters does not give the error. Path and filename have less than 75 characters. It's a really strange error!
Aug 10 2022 12:31 PM
@JavaLuigi This is caused by KB5002242, and happens when opening Excel files saved on a shared drive (or other UNC path), where the total length of the path and file name exceed about 90 characters. The normal maximum length is 218 characters. Uninstalling KB5002242 is a temporary fix for getting rid of the error message.
Aug 10 2022 12:32 PM
Aug 10 2022 12:35 PM
@JavaLuigi Thank you for the confirmation. Glad to find someone else with the issue. I hope someone takes notice and they fix it soon. In my case the file is a master document index that has a shortcut on the desktop of all users. I would rather not have to change the path or filename especially since it is part of the quality system in our company.
Aug 10 2022 12:36 PM
Aug 10 2022 11:40 PM
@MikeRabeThank you for your information. Yes, hopefully they will fix it asap. In between we will answer the Excel question with yes. But this can only be a temporary solution. You are right the limit is exactly 90 characters (UNC path and filename).
May 13 2023 10:45 AM
Hi dear Mr. Robbins. I also have faced with this problems. could u plz guide me? the original file created in excel 97-2003 in a laboratory computer.
thanks a lot
hakimi
Sep 27 2023 03:59 PM
Hi
I am having a similar problem and some people on the thread mentioned to upload the file onto here to get help. How do i do that?
Thanks in advance.
Sep 27 2023 04:18 PM
@VijayUK When you click on Reply, use the "Drag and drop here or browse for files to attach" facility to select the file that you want to upload
Nov 19 2023 11:45 AM
Hi
I am having a similar problem. Have you already solved this problem? If you have, could you please help me?
Thanks in advance.
Nov 19 2023 02:10 PM
@April_han If you upload a copy of the file, we can investigate the problem.
Jan 26 2024 12:54 AM
I have the same problem in one of my files. I want to upload a copy of my excel file (all my files have .xls extension since i use 97-2003 version of excel), but I don't know how to upload a copy of my file. Please let me know if you can help. Thanks.
Jan 26 2024 01:08 AM
@wiser2013yahoocom When you click on Reply, you will see the facility outlined in Red that can be used to upload your file(s)
Mar 14 2024 05:14 AM
I permanently deleted an excel spreadsheet and since recovering the file it wont open due to it being created on an older version of excel. Can you change the format for me please. I've tried with no success.