Jul 04 2020 05:21 AM
Hi All,
I have a excel.xlsx file saved in my system which has been corrupted .I atleast need to recover the data stores .It is a file of 124 KB and has around 35 worksheets in the workbook .I have tried all possible ways to recover and repair the file .i even tried to extract the data using 3rd party application like stellar,ease of use recover application of excel still i have no luck . The below error message im getting whenever i try to open the file.I even tried to open it through other applications like wordpress,google sheets and so on but nothing works .
Thanks and regards ,
Muthuraman
Jul 04 2020 07:39 AM
Sep 11 2020 04:45 AM
This error message is encountered in the following scenarios:
I copied and pasted the file to my desktop, right-click and changed '.xlsx' to '.xls'. Boom!! I got my file back.
Try to open your corrupt file in safe mode. Press Windows+R and write excel.exe /safe and click OK. Good Luck
Oct 15 2020 07:06 PM
@Muthu69 Hi. If you have tried all possible methods to repair your Excel file but none of them work, then maybe your Excel file is not corrupted, but you just don’t have permission to open it on your system. If you don’t have permission to open the Excel file, it will display the error "Excel cannot open the file because the file format or file extension is not valid." I have tested this on my Windows 10. You can use the following steps to grant everyone on this computer permission to open the Excel file.
That’s it. Now check if you can open the Excel file without any problems. If you want an illustrated guide, refer to this page: https://www.isumsoft.com/office/excel-cannot-open-the-file-because-extension-is-not-valid.html#way2
Please tell me if this helps. Good luck!
Nov 18 2020 07:47 AM
Nov 18 2020 07:53 AM
Nov 18 2020 09:52 AM
With your permission and everyone involved, if I can recommend.
It can help us all if you upload an Excel file, no picture.
You could get a precise solution much faster with a file.
This would also be a blessing for all of us,
as we can understand the problem much better,
a win-win situation for everyone.
*Knowledge of Excel version and the operating system is a must have if you want to proposing a reasonable solution (Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.).
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Feb 08 2021 06:31 AM
how do you right click andchange to XLS? this doesn't work for me - there is nowhere to change the xlsx toxls?!?!?@victoriyaluna
Feb 08 2021 07:06 AM
Repair a damaged workbook
Click on File> Open.
Click the location and folder that contains the damaged workbook.
In the Open dialog box, select the damaged workbook.
Click the arrow next to the Open button, and then click Open and Repair
Repair a corrupted workbook
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Feb 09 2021 09:35 AM
I would like to try your solution for fixing the corrupt file by changing the extension, but I cannot find where to click to access it. How do I change it? Once I save the file to the desktop, right click, what do I do next?
Feb 09 2021 09:55 AM
In File Explorer, I clicked on view tab at the top and selected the option to show extensions. Then I renamed the extension to xls. Unfortuatenly, when the document opened, it was blank - thankfully it was a copy. Now I just need a different solution. I do appreciate your trying to help!
Mar 21 2021 06:57 PM
Mar 22 2021 01:42 AM - edited Mar 22 2021 02:22 AM
It was probably not saved as an Excel file.
Before repairing, please change all Excel files to All files (*. *) .
If this is not the case either, it is very likely that it will no longer be possible to restore the file.
Additional Info:
Repairing a corrupted workbook
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Apr 09 2021 10:07 AM
In my case, the same problem occured after I moved my One Drive folder to another disk, because the original location had no more space.
After moving, the files in the new place became outdated, probably because local files were not synchronized with the cloud.
I deleted the original One Drive folder, and the system asked for a complete deletion, because the folder was too big.
After knowing that some of my spreadsheets were outdate, I recovered them using third party software, but Excel doesn't open them, the message is the same in this post.
I've tried all solutions posted here, and also all solutions proposed by Microsoft, but I had no success. It's frustrating because I can see that the size of the recovered file is a little bigger than the outdated file, what is coherent. Also, the same problem occurs with all spreadsheets restored. I still think that this thing is related to One Drive.
Finally, I tried to attach one of the files and received the error message:
Apr 09 2021 11:39 AM
With your permission, please open a new post when you like to make a new ask.
In this way, the different problems and solution approaches can be more easily understood for all members in the forum.
For those who have received a proposed solution in this post and thus solved their problem, I would like to ask you to mark the proposed solution as a correct answer and / or as a like (thumbs up), so that other members can also be better helped in the future.
That is the least that a person seeking help can do to pass on help.
At the same time, if I may recommend, always include a file (without sensitive data) in your request as far as possible. Describe your request as detailed as possible based on this file.
This is how you can help yourself and everyone who wants to help.
Thank you for your patience and understanding,
Nikolino
I know I don't know anything (Socrates)
Apr 12 2021 11:11 PM
Aug 13 2021 08:20 AM
I encountered the same problem on a flow that HAD been working. Does this solve your problem?
Short version:
On Create File command, I was using “Current Item” in File Content field.
I changed that to use “Attachments Content” instead and now it works just fine.
Step 1: Initiate the workflow with “When a new email arrives….” Add whatever filtering conditions.
Step 2: Choose New Action, SharePoint, Create File.
Provide Site address, folder path, filename (with extension)
Step 3: for File Contents, choose “Attachment Content” from the Dynamic Content menu.
Do NOT choose “Current Item”.
When you choose “Attachments Content”, it will automatically transform Create File to be inside a loop and will look like this:
Once I made that change (use “Attachments Content” in File Content field) the Excel files I created opened correctly without error.
Credit to That Office Guy: How to Save email attachments with Power Automate
He was saving to OneDrive seeing him use “Attachment Content” for File Content solved my problem.