File in Excel got corrupted or dissapeared

%3CLINGO-SUB%20id%3D%22lingo-sub-2042343%22%20slang%3D%22en-US%22%3EFile%20in%20Excel%20got%20corrupted%20or%20dissapeared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042343%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20been%20an%20excel%20user%20for%2025%20years.%20This%20had%20never%20happened%20to%20me.%20I%20created%20a%20draft%20of%20a%20process%20map%20last%20night%20and%20then%20opened%20it%20today%20to%20work%20with%20a%20colleague%20on%20it%20over%20zoom.%20Out%20of%20the%20sudden%20the%20file%20just%20dissapeared.%20I%20first%20thought%20that%20I%20had%20closed%20it%20by%20mistake%20but%20I%20just%20could%20not%20open%20the%20darn%20thing%20again.%20I%20tried%20to%20repair%20it%20and%20did%20not%20work.%20I%20can%20see%20the%20file%20and%20the%20content%20on%20the%20file%20manager%20preview%20pane%20but%20just%20cannot%20open%20it%20and%205%20hours%20of%20work%20went%20down%20the%20drain.%20When%20I%20try%20to%20open%20it%20I%20get%20a%20notification%20about%20a%20potential%20security%20concern.%20When%20I%20click%20on%20disable%2C%20Excel%20does%20nothing.%20I%20just%20get%20a%20blank%20screen.%20If%20I%20click%20on%20enable%2C%20I%20get%20another%20security%20notice%20asking%20me%20if%20I%20should%20update%20the%20external%20links%2C%20whatever%20I%20do%2C%20I%20get%20the%20same%20blank%20screen.%20And%20the%20file%20does%20not%20have%20any%20links%20to%20any%20external%20files.%20This%20is%20really%20weird.%26nbsp%3B%20The%20file%20is%20just%20513%20Kb%C2%B4s!!%20I%20enclose%20screen%20prints.%20I%20enclose%20the%20file.%20I%20do%20not%20understand%20how%20I%20can%20see%20it%20on%20the%20preview%20pane%20perfectly%20but%20cannot%20open%20it.%20Help!!!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Blank_Screen.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244825iDBB390F9B1652F22%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Blank_Screen.png%22%20alt%3D%22Blank_Screen.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Preview-VSM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244826i5C16616154333EA6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Preview-VSM.png%22%20alt%3D%22Preview-VSM.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Security_Notice.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244827iF6AAC11AFA61AF14%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Security_Notice.png%22%20alt%3D%22Security_Notice.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Unsafe_Links.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244828i8A0C220C7AAFA39E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Unsafe_Links.png%22%20alt%3D%22Unsafe_Links.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2042343%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2042665%22%20slang%3D%22en-US%22%3ERe%3A%20File%20in%20Excel%20got%20corrupted%20or%20dissapeared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042665%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921850%22%20target%3D%22_blank%22%3E%40intercambi%3C%2FA%3E%26nbsp%3BYou%20have%20accidentally%20hidden%20your%20workbook.%20Click%20%22unhide%22%20(bottom%20right-hand%20corner%20of%20the%20first%20picture)%20on%20the%20view%20ribbon.%20Select%20the%20workbook%20and%20it%20will%20re-appear.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-01-08%20at%2008.00.30.png%22%20style%3D%22width%3A%20604px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244851iB8DE3EF1EFB2C7A3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-01-08%20at%2008.00.30.png%22%20alt%3D%22Screenshot%202021-01-08%20at%2008.00.30.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-01-08%20at%2008.00.47.png%22%20style%3D%22width%3A%20381px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244852iAD90673866720999%2Fimage-dimensions%2F381x378%3Fv%3D1.0%22%20width%3D%22381%22%20height%3D%22378%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-01-08%20at%2008.00.47.png%22%20alt%3D%22Screenshot%202021-01-08%20at%2008.00.47.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, I have been an excel user for 25 years. This had never happened to me. I created a draft of a process map last night and then opened it today to work with a colleague on it over zoom. Out of the sudden the file just dissapeared. I first thought that I had closed it by mistake but I just could not open the darn thing again. I tried to repair it and did not work. I can see the file and the content on the file manager preview pane but just cannot open it and 5 hours of work went down the drain. When I try to open it I get a notification about a potential security concern. When I click on disable, Excel does nothing. I just get a blank screen. If I click on enable, I get another security notice asking me if I should update the external links, whatever I do, I get the same blank screen. And the file does not have any links to any external files. This is really weird.  The file is just 513 Kb´s!! I enclose screen prints. I enclose the file. I do not understand how I can see it on the preview pane perfectly but cannot open it. Help!!!Blank_Screen.pngPreview-VSM.pngSecurity_Notice.pngUnsafe_Links.png

2 Replies

@intercambi You have accidentally hidden your workbook. Click "unhide" (bottom right-hand corner of the first picture) on the view ribbon. Select the workbook and it will re-appear.

Screenshot 2021-01-08 at 08.00.30.pngScreenshot 2021-01-08 at 08.00.47.png

Attaching the "unhidden" file for your convenience.

@intercambi 

 

There are many reasons for this error:

1. Unsaved work

2. Format conversion

3. Merging cells

4. Cell formatting

 

You can read this blog