Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How do I recover lost data?

0

I wanted to input data from one worksheet into another, and I tried to open two windows simultaniously to move from one to the other.  Now one of my worksheets shows nothing but a blank blue screen.  No columns, rows or any data.  How do I recover my worksheet?

Answer
Discuss

Answers

1

Depending on your version of Excel, you could try these steps:

  1. Click the File button.
  2. Click Recent.
  3. Click Recover Unsaved Workbooks.
  4. Select the Workbook.
  5. Click Open
  6. Save the file.

More information here.

Discuss
0

If something more global has happened, try data recovery software: https://www.cleverfiles.com/word-excel-recovery.html

Discuss

Discussion

This is obviously a promo post and I have never used this software so I can't vouch for it. That said, try the methods listed in the other answers before you try this.
don (rep: 1989) Sep 30, '17 at 5:22 am
Add to Discussion
0

 Obviously, the blue window doesn't hold the missing workbook. Therefore the missing workbook is in a location other than where you expect it to be. Click the "View" tab on the ribbon and "Switch Windows". You will see all open documents listed. I hope that is where you will find your missing workbook.

Incidentally, while you are looking for it, there is a button to the left of "Switch Windows" with the caption "View side by side". That is the one you might have used to achieve what you wanted to do.

If the workbook is not listed in the "Switch Windows" dropdown not everything is lost yet. There is a chance that you opened the second sheet in another instance of Excel. Quit the instance which doesn't have the missing workbook. If there is another isntance running simultaneously it will come to the top of the heap and, with luck, your workbook will turn up there.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login