Spreadsheet Disappeared

%3CLINGO-SUB%20id%3D%22lingo-sub-3428324%22%20slang%3D%22en-US%22%3ESpreadsheet%20Disappeared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3428324%22%20slang%3D%22en-US%22%3E%3CP%3EA%20spreadsheet%20I%20was%20working%20on%20went%20blank.%26nbsp%3B%20Not%20sure%20what%20button%20I%20pushed.%26nbsp%3B%20The%20data%20appears%20to%20be%20there%2C%20but%20how%20do%20I%20make%20it%20visible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3428324%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3431988%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20Disappeared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3431988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1401563%22%20target%3D%22_blank%22%3E%40pclarkp1125%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20recover%20an%20unsaved%20Excel%20document%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20To%20do%20this%2C%20click%20on%20%22File%22%20in%20the%20ribbon%20and%20on%20%22Manage%20workbook%22%20in%20the%20%22Information%22%20area.%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20You%20can%20use%20the%20%E2%80%9CRestore%20unsaved%20workbooks%E2%80%9D%20menu%20item%20to%20find%20the%20unsaved%20Excel%20files%20and%20restore%20them.%3C%2FP%3E%3CP%3EExcel%20places%20the%20unsaved%20changes%20in%20the%20C%3A%5CUsers%5C%5CAppData%5CLocal%5CMicrosoft%5COffice%5CUnsavedFiles%20folder.%3C%2FP%3E%3CP%3EYou%20also%20have%20access%20to%20the%20files%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAutomatic%20saving%20protects%20against%20data%20loss%3C%2FP%3E%3CP%3EExcel%20uses%20its%20own%20data%20backup%2C%20which%20automatically%20saves%20your%20intermediate%20status%20at%20regular%20intervals.%20However%2C%20you%20must%20activate%20these%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20To%20do%20this%2C%20go%20to%20the%20%22File%22%20tab%20and%20click%20on%20%22Options%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20In%20the%20next%20window%2C%20select%20%22Save%22%20and%20check%20the%20%22Save%20AutoRecover%20information%20every...%22%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Enter%20the%20desired%20interval%20at%20which%20Excel%20should%20save%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Check%20the%20option%20%22Keep%20the%20last%20automatically%20saved%20version%20when%20closing%20without%20saving%22.%3C%2FP%3E%3CP%3EThen%20it%20will%20be%20easier%20to%20restore%20the%20last%20used%20Excel%20file%20when%20the%20program%20exits%20unexpectedly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3433446%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20Disappeared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3433446%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1401563%22%20target%3D%22_blank%22%3E%40pclarkp1125%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESounds%20like%20the%20workbook%20is%20set%20to%20hidden%20or%20the%20sheet%20is%20open%20but%20minimized.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20restore%20a%20hidden%20workbook%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Patrick2788_0-1653570882426.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Patrick2788_0-1653570882426.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F375425iBE966346EDD53B71%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Patrick2788_0-1653570882426.png%22%20alt%3D%22Patrick2788_0-1653570882426.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20the%20sheet%20is%20present%20but%20minimized%20and%20out%20of%20view%2C%20go%20to%20View%20%7C%20Arrange%20All%20-%20pick%20tiled%26nbsp%3B%20and%20that%20may%20bring%20it%20back%20into%20view.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

A spreadsheet I was working on went blank.  Not sure what button I pushed.  The data appears to be there, but how do I make it visible?

2 Replies

@pclarkp1125 

You can recover an unsaved Excel document:

 

    To do this, click on "File" in the ribbon and on "Manage workbook" in the "Information" area.

    You can use the “Restore unsaved workbooks” menu item to find the unsaved Excel files and restore them.

Excel places the unsaved changes in the C:\Users\\AppData\Local\Microsoft\Office\UnsavedFiles folder.

You also have access to the files there.

 

 

Automatic saving protects against data loss

Excel uses its own data backup, which automatically saves your intermediate status at regular intervals. However, you must activate these:

    To do this, go to the "File" tab and click on "Options".

    In the next window, select "Save" and check the "Save AutoRecover information every..." box.

    Enter the desired interval at which Excel should save the data.

    Check the option "Keep the last automatically saved version when closing without saving".

Then it will be easier to restore the last used Excel file when the program exits unexpectedly.

 

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

 

@pclarkp1125 

Sounds like the workbook is set to hidden or the sheet is open but minimized.

 

To restore a hidden workbook:

Patrick2788_0-1653570882426.png

If the sheet is present but minimized and out of view, go to View | Arrange All - pick tiled  and that may bring it back into view.