+ Reply to Thread
Results 1 to 5 of 5

Excel Error when opening

  1. #1
    Registered User
    Join Date
    10-17-2019
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    1

    Excel Error when opening

    I have been working on a spreadsheet and saved. Upon re-opening it I receive the following message, screen grab attached too:


    Excel Cannot Open the File/the File Format or File Extinction Is Not Valid. ... Verify that the file has not been corrupted and that the file extension matches the format of the file.


    i've attempted a repair, which fails. I have full permissions on the file.
    Attached Images Attached Images

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Excel Error when opening

    Have you repaired your Office installation also?

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Excel Error when opening

    Hi, welcome to the form.
    I hope your file isn't ripe for extinction like the dinosaurs
    The message just tells you that there is something wrong with the contents of the file.
    You're using Office 365 so the extension is either xlsx (which it shows) or you erroneously named it xlsx while it's an older Excel version and should have been xls.
    Another plausible reason is that you have a customized ribbon but that I cannot tell from the information you have provided.
    Guessing and assuming won't help you.
    You will have to recap what you did before this happened, what did you change, etc.
    I know it's not much to go on for you but ...
    If the file doesn't contain private data you can attach it as it is and maybe someone can see what's wrong.
    You can also open Excel in safe mode, hold down the Ctrl of Shift key while the file is double-clicked to open
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  4. #4
    Registered User
    Join Date
    04-09-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Excel Error when opening

    Quote Originally Posted by RobBeard86 View Post
    I have been working on a spreadsheet and saved. Upon re-opening it I receive the following message, screen grab attached too:


    Excel Cannot Open the File/the File Format or File Extinction Is Not Valid. ... Verify that the file has not been corrupted and that the file extension matches the format of the file.


    i've attempted a repair, which fails. I have full permissions on the file.
    Try the following solutions:

    Solution 1: Rename the Excel file with .xml extension and then open Excel application. Goto File menu | Open and try to open the xml file.

    Solution 2
    1- Copy your filename.xlsx on C drive (for quick finding)

    2- Run command prompt as an administrator (for all rights)

    3- Change file extension to xls using rename command "rename filename.xlsx filename.xls"

    4- Open file in excel.... enjoy

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Excel Error when opening

    @steve
    Administrative Note:

    Please don't quote entire posts unnecessarily. They are just clutter and make threads hard to read.
    Use the "Quick reply" instead
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. error opening excel file
    By roofi in forum Excel General
    Replies: 2
    Last Post: 07-19-2013, 02:06 AM
  2. serious error on opening excel
    By mr boover in forum Excel General
    Replies: 5
    Last Post: 06-22-2013, 01:08 PM
  3. Replies: 2
    Last Post: 09-12-2012, 01:01 PM
  4. Run time Error 91 when opening Excel
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-18-2011, 09:15 AM
  5. Error on opening outside of Excel
    By ChemistB in forum Excel General
    Replies: 2
    Last Post: 12-17-2008, 11:13 AM
  6. Getting error when opening excel 2007
    By sniper22x in forum Excel General
    Replies: 3
    Last Post: 03-06-2007, 06:29 PM
  7. error opening excel
    By NANcy05 in forum Excel General
    Replies: 1
    Last Post: 03-20-2006, 04:00 PM
  8. error opening excel file
    By jp in forum Excel General
    Replies: 2
    Last Post: 02-18-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1