How to Solve Excel Cannot Open the File ... Because the File Format or File Extension Is Not Valid.

Поделиться
HTML-код
  • Опубликовано: 21 окт 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).

Комментарии • 129

  • @MDTechVideos
    @MDTechVideos  4 года назад +2

    Did I help you? Consider a one time contribution to support new daily content on this channel. www.paypal.me/MDTechVideos

  • @yuanli1948
    @yuanli1948 4 года назад +47

    still can not open............................... big cry..

    • @erickalvarez3256
      @erickalvarez3256 4 года назад +5

      me too

    • @yamintzk778
      @yamintzk778 4 года назад +4

      me too, cannot open

    • @annibraun5089
      @annibraun5089 4 года назад +7

      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.

    • @chinnichinnu2264
      @chinnichinnu2264 4 года назад +1

      @@annibraun5089 can you help me out in resolving the issue, It whould be a great help. What is that 3rd party application???

    • @jojotree6878
      @jojotree6878 4 года назад +1

      @@annibraun5089 so what is the tools name? stellar?

  • @msv9389
    @msv9389 11 месяцев назад

    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 !!

  • @andolik
    @andolik 7 месяцев назад

    Great job man. Saved me a lot of head aches. good job. Solved my problem I have been having off and on.

  • @martinvanzyl747
    @martinvanzyl747 4 года назад +3

    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?????

  • @mdfaridul8335
    @mdfaridul8335 Год назад +1

    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 RUclipsr. 👍👍

  • @z-world1991
    @z-world1991 2 года назад +2

    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

  • @fernafepatoy8936
    @fernafepatoy8936 4 года назад +2

    It says mine when I open the "Securtity"
    "The requested security information is either unavailable or can't be displayed"

  • @whydidinamethischannelthis2409
    @whydidinamethischannelthis2409 4 года назад

    Every single problem i have your name comes up on the list when I search for a fix, thanks!

  • @alvin012784
    @alvin012784 25 дней назад

    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

  • @gracefernandez7890
    @gracefernandez7890 2 года назад

    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.

  • @marcw.5492
    @marcw.5492 Год назад

    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

  • @queen_j1422
    @queen_j1422 11 месяцев назад

    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

  • @kimberleyhuber3686
    @kimberleyhuber3686 4 года назад +1

    i am unable to select 'properties' it is not in bold...

  • @deanettem
    @deanettem Год назад

    hello I do not have the security tab is there some other way to change to "everyone"

  • @awaismumtaz6273
    @awaismumtaz6273 Год назад

    Bundle of thanx :) i recovered most important file within few minutes. Again thanks such a very helpful video.

  • @omer0044
    @omer0044 2 года назад +2

    I don't get security tap option :(

  • @imranhasme.andofficial1320
    @imranhasme.andofficial1320 11 месяцев назад

    not yet to 0pen bro for excel file so what can i do please say something.

  • @jakeanderson5
    @jakeanderson5 Год назад

    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.

  • @MegaNatebreezy
    @MegaNatebreezy 2 года назад

    but what if i don't want everyone to have access to it?

  • @qpfj
    @qpfj 3 года назад +2

    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.

  • @nareshtalari4649
    @nareshtalari4649 2 года назад

    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

  • @sciencebehindfitness4335
    @sciencebehindfitness4335 2 года назад +1

    Did the same.... But still the error message persists

  • @chiragshah8531
    @chiragshah8531 4 года назад +3

    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

  • @Unzeina
    @Unzeina 7 месяцев назад

    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.

  • @w.n.shafiq8879
    @w.n.shafiq8879 3 года назад +1

    why i try syill cannot open...

  • @kiyameribo2504
    @kiyameribo2504 3 года назад

    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?

    • @MDTechVideos
      @MDTechVideos  3 года назад

      Sounds like ransomware, probably a total loss. I am sorry.

  • @dishoffice6534
    @dishoffice6534 2 года назад

    sir ill try this but same problem, not working please help me sir

  • @rinokumura8518
    @rinokumura8518 2 года назад +2

    Not worked....please help me😭

    • @melsa8594
      @melsa8594 2 года назад +1

      is it opened? i'm trying but still not working

  • @amandalatter6803
    @amandalatter6803 4 года назад +6

    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 :)

  • @ArethaAgatha27
    @ArethaAgatha27 Год назад

    Thanks for the information that you has give sir🙏🏻😇

  • @dishoffice6534
    @dishoffice6534 2 года назад

    sir im try this tricks, but this not working, sir please help me

  • @shahidmansuri7244
    @shahidmansuri7244 2 года назад

    Shs screp file ko ms ward me kese opan kar sakte he

  • @martinatube2332
    @martinatube2332 4 месяца назад

    Thank you I solve my problem by this video

  • @phubtshering9692
    @phubtshering9692 2 года назад

    Its not working, kindly help me to get my file

  • @musicbox9973
    @musicbox9973 3 года назад

    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

  • @ahmeddeyab1553
    @ahmeddeyab1553 Год назад

    Thank you very much, Helpful ❤️

  • @octavio9648
    @octavio9648 3 года назад +1

    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?

    • @ピカ中トロ
      @ピカ中トロ 3 года назад

      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.

  • @erandeser5830
    @erandeser5830 8 месяцев назад

    The effing nonsense. 30 or more years excel exists. And when I create a spreadsheet impossible to open after.

  • @tariqhaddad7298
    @tariqhaddad7298 4 года назад

    open with it says unknown application

  • @vhtprints776
    @vhtprints776 2 года назад

    still can not open :(

  • @veronicanjoki4223
    @veronicanjoki4223 2 года назад +2

    THANK YOU SIR💯💯💯

  • @rowland138
    @rowland138 4 месяца назад +1

    Thankx a lot

  • @kiranmayekar6440
    @kiranmayekar6440 2 года назад

    Not working

  • @Aryan77028
    @Aryan77028 2 года назад

    it is big fix thnx a lot and it was very helpful

  • @mzml4696
    @mzml4696 2 года назад

    You saved my day.

  • @zaidapongcol5488
    @zaidapongcol5488 3 года назад

    Thanks bro, and here I thought my files are gone. Thank you.

  • @emadavz5295
    @emadavz5295 4 года назад

    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.

  • @spongebobsquarepants3144
    @spongebobsquarepants3144 3 года назад +1

    Love ya, man! Thank You...

  • @williamtay6219
    @williamtay6219 Год назад

    Thanks. It works 😊

  • @israaonline1
    @israaonline1 3 года назад

    I did not help

  • @tanmaypanchal4891
    @tanmaypanchal4891 2 года назад

    Thnx mate, it worked🙏😀

  • @qbw2335
    @qbw2335 Год назад

    it works !!! thanks !

  • @DurgaPrasad-mn2vx
    @DurgaPrasad-mn2vx Год назад

    Thank you

  • @ashishagarwal7193
    @ashishagarwal7193 Год назад

    THANKU SIR

  • @dhakshayinigangaraju9895
    @dhakshayinigangaraju9895 Год назад

    Tq very much sir

  • @allisonfranklin698
    @allisonfranklin698 4 года назад +1

    Thank you for kind help

  • @jayeshnayak2991
    @jayeshnayak2991 Год назад

    Thanks

  • @johannazulkifli4
    @johannazulkifli4 4 года назад

    HELLO MICROSOFT!! BIG SELLING POINT TO MAKE THIS SHIT A LOT MORE EASIER!

  • @eldapadilla6704
    @eldapadilla6704 3 года назад

    Gracias, gracias por su ayuda. Que Dios le siga dando mas habilidades para que nos siga ensenando. :)

  • @76honda76
    @76honda76 4 года назад

    Works for me. thank you so much!

  • @nizarali2305
    @nizarali2305 Год назад

    May god bless you

  • @ASTRONAGA
    @ASTRONAGA 4 года назад

    Thank you bruhQ

  • @ahacibo
    @ahacibo 4 года назад

    Works for me. Thank you.

  • @ArbazKhan-pn2pn
    @ArbazKhan-pn2pn 5 месяцев назад

    Jisa bola tha vise he kiya to be na hoto

  • @wandyaprianto6334
    @wandyaprianto6334 3 года назад

    Thankyou!! holy goddnesss it still can't work

  • @MOHAMED-sl3wr
    @MOHAMED-sl3wr 4 года назад

    Good work

  • @Aryan77028
    @Aryan77028 2 года назад

    Thank you - you're a genius!

  • @ashtoncaftern5929
    @ashtoncaftern5929 4 года назад

    This man is my g

  • @fayyazahmad5962
    @fayyazahmad5962 2 года назад

    this video is not sport this solve problem

  • @timothymills8047
    @timothymills8047 Год назад

    BRUH THIS SHIT STILL NOT WORKING

  • @Intimahesh
    @Intimahesh 4 года назад

    It's working TQ

  • @krishnadhanroy7696
    @krishnadhanroy7696 2 года назад

    Good

  • @maheklal3329
    @maheklal3329 2 года назад

    works

  • @dishoffice6534
    @dishoffice6534 2 года назад

    sir ill try this but same problem, not working please help me sir

  • @dishoffice6534
    @dishoffice6534 2 года назад

    sir im try this tricks, but this not working, sir please help me

  • @reinafebasultin266
    @reinafebasultin266 2 года назад

    Thank you

  • @kabeerahmad4339
    @kabeerahmad4339 3 года назад

    Thanks