How to Solve Excel Cannot Open the File ... Because the File Format or File Extension Is Not Valid.
ฝัง
- เผยแพร่เมื่อ 30 พ.ย. 2024
- How to Solve Excel Cannot Open the File ... Because the File Format or File Extension Is Not Valid.
Did you get an error message of 'Excel cannot open the file **.xlsx because the file format or file extension is not valid' while trying to open a file? Quick fixes and advanced solutions are available here to fix this problem and access your document.
Sometimes, when you try to open or edit an Excel file on Microsoft Office 2003, 2007, 2010, 2013 or 2016, you may encounter the following problem:
"Excel cannot open the file 'filename.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
Microsoft Excel is a widely used application by large as well as small organizations for managing their financial data, daily work reports, and other tasks. But, many users often face a common error while opening a file in Excel, especially when opening a spreadsheet received through an email, “Excel cannot open the file ‘(filename)’.xlsx because the file format for the file extension is not valid.”
It usually indicates the file is not compatible with the Excel version or the file has come corrupt or damaged. In this tutorial, we will show you all the possible solutions, and you can try them respectively until fixing the issue.
This tutorial will apply for computers, laptops, desktops,and tablets running the Windows 10, Windows 8/8.1, Windows 7 operating systems.Works for all major computer manufactures (Dell, HP, Acer, Asus, Toshiba, Lenovo, Samsung).
Did I help you? Consider a one time contribution to support new daily content on this channel. www.paypal.me/MDTechVideos
Sir but wrong kar diye plz help me
Folder not show
unfortunately it did not work for me
still can not open............................... big cry..
me too
me too, cannot open
After doing all, still excel file not opening and showing the same error. All excel files in a particular folder are corrupted. New files and the files in other folders are working properly.
After two weeks I use a third party excel repair tool suggested by one of my friends. This tool by stellar helps me to find out the corruption in the .xls file and repair it in very little time.
@@annibraun5089 can you help me out in resolving the issue, It whould be a great help. What is that 3rd party application???
@@annibraun5089 so what is the tools name? stellar?
Totally saved the day!!!! Couldn’t get Excel files to open up at all in my shared Dropbox at work. Followed your prompts in video and I’m back up and running. Thank you !!
Glad I could help
Thank You!
In the office 10 some setting have changed. But I'm Try very Hardly. & Alhamdulillah, Almighty Allah Help Me For success This work.
At Last Thank you TH-camr. 👍👍
Please help. my laptop just came back from guarantee repair. Downloaded and installed Office 365, where I have many Excel files saved. I can open and download them, but they won't open in this pc. In file explorer, I can only see them on Onedrive. If I open Excel from the start menu, I only get the Onedrive option. What now?????
Great job man. Saved me a lot of head aches. good job. Solved my problem I have been having off and on.
Glad to help!
It says mine when I open the "Securtity"
"The requested security information is either unavailable or can't be displayed"
I don't get security tap option :(
I formated my hard drive and then i recovered it but all my data and video files are corrupted. I follow your procedure but it's not working. Kindly tell me solution
did u finnd
Followed instructions to a "T" and no dice for me --- Bummer Man! But it worked for a lot of other people. Win some lose some --- now time to move on.
Would you tell me how to fix the same error message on my mac? I tried copying your steps, but, they're not the same on my mac.
i am unable to select 'properties' it is not in bold...
Every single problem i have your name comes up on the list when I search for a fix, thanks!
You're welcome!
I went through all those steps, but "Everyone" already had access. As a matter of fact when I clicked on Edit under everyone...it says FULL CONTROL, but all the check marks are grayed out
How can you suppress the error message that come sup in File Type situtation that never occurred in porevious versions ? Is there a setting somewhere in EXCEL ? My macro has worked for 20 years ! now it no work any longer. Tried adding code in macro - but no luck. Application.DisplayAlerts = False
Under security Tab, no list of users shown even the adminstrator.accidentally removed due go edit made by some network user. When i try to edit permission me, myself as adminstrator was also accidentally removed. How to recover??? Please help
If this is not still working- check if you have [#] hashtags or your file names. In our cade that turned out to be the issue.
hello I do not have the security tab is there some other way to change to "everyone"
Bundle of thanx :) i recovered most important file within few minutes. Again thanks such a very helpful video.
not yet to 0pen bro for excel file so what can i do please say something.
How to fix Name conflict in Excel
I tried to fix it by googling and you tube and still I'm unable to did it... Plz sort it sir
Did the same.... But still the error message persists
same here...
Thank you I solve my problem by this video
why i try syill cannot open...
i follow your steps but not recovered may be the file is attacked by hackers and they ask me to pay so what shall i do?
Sounds like ransomware, probably a total loss. I am sorry.
Thank you so so much...my most important file got this issue..I was so worried thought I will have to do it all again but thanks to you it sorted...thank you once again
Glad I could help
Thanks a lot for this useful information!
Also, I read that we can fix this issue with the "Open and Repair" method too which worked out for me.
THANK YOU SIR💯💯💯
Most welcome
Not worked....please help me😭
is it opened? i'm trying but still not working
Shs screp file ko ms ward me kese opan kar sakte he
sye punya general tu xde. change to. folder mcm shortcut. sbb sye buka 2 folder, nama file tu save sama. sye tekan je 😅help help
but what if i don't want everyone to have access to it?
sir ill try this but same problem, not working please help me sir
Thank you very much, Helpful ❤️
Glad it helped!
sir im try this tricks, but this not working, sir please help me
Thanks for the information that you has give sir🙏🏻😇
All the best
Thankx a lot
Thank you - you're a genius! After an hour of me trying to figure it out, I found your page and took your advice and BINGO! 5 Stars for you my friend :)
Glad I could help!
Its not working, kindly help me to get my file
open with it says unknown application
HELLO MICROSOFT!! BIG SELLING POINT TO MAKE THIS SHIT A LOT MORE EASIER!
You saved my day.
Glad it helped
I read that you can change the File Extension of the Excel Sheet to a DOC or from .xls to .xlsx, but how do you do that if the file won't open?
Hey, you might not need to know this anymore but here are the steps. Go to File Explorer or any folder, at the top there is a "view" tab, click on it and you should see a "Show/Hide" section with one of the boxes named "File name extensions". You simply click on it and it should show the extension (e.g .xlsx) behind each document name.
I think the method you are referring to requires you to change the extension by renaming the .xls to .xlsx, BEFORE doing this I would recommend you to make a copy of the file as this can lead to the file becoming completely blank.
it is big fix thnx a lot and it was very helpful
Glad I could help
The effing nonsense. 30 or more years excel exists. And when I create a spreadsheet impossible to open after.
still can not open :(
Thank you
You're welcome
I did not help
Thanks. It works 😊
You're welcome!
Love ya, man! Thank You...
Glad to help!
Thnx mate, it worked🙏😀
Glad it helped
it works !!! thanks !
Glad to help.
Not working
Jisa bola tha vise he kiya to be na hoto
Thankyou!! holy goddnesss it still can't work
You're welcome!
Thanks
Glad it helped
Tq very much sir
Welcome
THANKU SIR
Glad it helped!
Thank you for kind help
You're welcome!
May god bless you
You're welcome!
Thanks bro, and here I thought my files are gone. Thank you.
Glad it helped!
Thank you soooooooooooo much. i have been trying for hours to figure out how to change the setting to be able to open it on my laptop and this helped solve it.
Glad I could help
this video is not sport this solve problem
BRUH THIS SHIT STILL NOT WORKING
Thank you bruhQ
Happy to help
Good work
Thanks for the comment Mohamed.
Gracias, gracias por su ayuda. Que Dios le siga dando mas habilidades para que nos siga ensenando. :)
Good
You're welcome!
This man is my g
You're welcome!
Works for me. thank you so much!
You're welcome!
Works for me. Thank you.
You're welcome!
It's working TQ
works
Glad it helped!
Thank you - you're a genius!
You're welcome!
sir ill try this but same problem, not working please help me sir
sir im try this tricks, but this not working, sir please help me
Thank you
Thanks
Glad I could help!