SOLVED

Cannot open Excel File

%3CLINGO-SUB%20id%3D%22lingo-sub-3200895%22%20slang%3D%22en-US%22%3ECannot%20open%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3200895%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20opens%2C%20but%20my%20file%20won't%20open%20even%20though%20I'm%20clicking%20right%20on%20the%20filename.%3C%2FP%3E%3CP%3EIt%20keeps%20opening%20a%20blank%20file%20called%20%22Book1-%20Excel%22.%3C%2FP%3E%3CP%3EI%20use%20Windows%2011.%3C%2FP%3E%3CP%3EI%20just%20used%20this%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3200895%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3202654%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20open%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3202654%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1315010%22%20target%3D%22_blank%22%3E%40K9-Gal%3C%2FA%3E%26nbsp%3BDid%20you%20perhaps%20accidentally%20click%20on%20%3CSTRONG%3EHide%3C%2FSTRONG%3E%20in%20de%20View%20ribbon%20(Window%20group)%3F%20and%20upon%20closing%20Excel%20you%20confirmed%20to%20save%20changes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20then%20open%20the%20file%2C%20it%20will%20open%20in%20its%20hidden%20state%2C%20i.e.%20not%20visible.%20Go%20to%20the%20View%20ribbon%20and%20select%20%3CSTRONG%3EUnhide%3C%2FSTRONG%3E.%20You%20should%20then%20see%20your%20workbook%20there.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-02-23%20at%2008.19.36.png%22%20style%3D%22width%3A%20180px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350623i7BB27D4EA6D7EFEC%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-02-23%20at%2008.19.36.png%22%20alt%3D%22Screenshot%202022-02-23%20at%2008.19.36.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3206192%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20open%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3206192%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Riny%2C%3C%2FP%3E%3CP%3EYou%20may%20have%20the%20most%20brilliant%20idea%20yet%20--%20I%20do%20remember%20that%20I%20was%20doing%20a%20PAGE%20LAYOUT%20%2F%20PRINT%20TITLES%20when%20all%20of%20a%20sudden%2C%20it%20was%20gone!%26nbsp%3B%26nbsp%3BMaybe%20I%20clicked%20the%20wrong%20thing(%3F)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20spent%20so%20many%20hours%20last%20night%20trying%20to%20figure%20it%20out!%26nbsp%3B%20By%20now%20I've%20tried%20everything%20humanly%20possible%2C%20even%20MS%20Cha%20Support%20couldn't%20help.%20They%20just%20said%20do%20a%20Windows%20Upgrade--which%20didn't%20help%20at%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EToday%2C%20I%20am%20able%20to%20see%20the%20exact%20FILENAME%20in%20my%20FILE%20EXPLORER.%20It%20doesn't%20appear%20corrupt%20--%20it%20still%20shows%20the%20correct%20FILESIZE%2C%20FLENAME%2C%20PATH%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20I%20click%20on%20it%20(either%20left%20or%20right%20click)%2C%20it%20always%20opens%20a%20blank%20EXCEL%20document.%26nbsp%3B%20I%20cannot%20figure%20out%20which%20VIEW%20link%20you%20mean--the%20one%20in%20the%20FILE%20EXPLORER%20or%20the%20one%20in%20the%20blank%20worksheet%20document.%26nbsp%3B%20I%20tried%20both%2C%20but%20neither%20shows%20an%20UNHIDE.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20thinking%20outside%20the%20box!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3206213%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20open%20Excel%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3206213%22%20slang%3D%22en-US%22%3E%3CP%3EMessage%20says%20file%20may%20be%20corrupted%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1315010%22%20target%3D%22_blank%22%3E%40K9-Gal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Excel opens, but my file won't open even though I'm clicking right on the filename.

It keeps opening a blank file called "Book1- Excel".

I use Windows 11.

I just used this file.

6 Replies
best response confirmed by K9-Gal (Occasional Contributor)
Solution

@K9-Gal Did you perhaps accidentally click on Hide in de View ribbon (Window group)? and upon closing Excel you confirmed to save changes.

 

If you then open the file, it will open in its hidden state, i.e. not visible. Go to the View ribbon and select Unhide. You should then see your workbook there.

Screenshot 2022-02-23 at 08.19.36.png

@Riny_van_Eekelen 

Hi Riny,

You may have the most brilliant idea yet -- I do remember that I was doing a PAGE LAYOUT / PRINT TITLES when all of a sudden, it was gone!  Maybe I clicked the wrong thing(?)

 

I spent so many hours last night trying to figure it out!  By now I've tried everything humanly possible, even MS Cha Support couldn't help. They just said do a Windows Upgrade--which didn't help at all!

 

Today, I am able to see the exact FILENAME in my FILE EXPLORER. It doesn't appear corrupt -- it still shows the correct FILESIZE, FLENAME, PATH, etc.

 

However, when I click on it (either left or right click), it always opens a blank EXCEL document.  I cannot figure out which VIEW link you mean--the one in the FILE EXPLORER or the one in the blank worksheet document.  I tried both, but neither shows an UNHIDE.

 

Thank you for thinking outside the box!

Message says file may be corrupted@K9-Gal 

@K9-Gal not sure if you resolved it or not, but I meant the View ribbon in Excel. There you find the Hide and Unhide buttons as shown in the picture I uploaded earlier.

@Riny_van_Eekelen 

YOU ARE GENIUS!!!

Why did a MS Chat Support Tech waste HOURS of my time? These people are total AMATEURS. The answer was so simple, and should have been suggested FIRST. At least I didn't waste another 10 hours re-creating this very important company document.

Anyway, if you need a tech job in NJ, I will DEFINITELY put in an A+++ recommendation for you.

Lorenza Vidris,

Mainframe Programmer Analyst

 

No - it was "HIDDEN."