The missing data from the Excel sheet is faced due to a number of reasons like when you inadvertently disconnect the workbook Windows from the Excel while using the trio of restore windows buttons on the title bar and move the Windows under the status bar. In many cases, the worksheet hides by itself. So get the missing sheet tab unhide the worksheet.
Follow the steps to do so:
- Right click on any visible tab on the worksheet > click Unhide
- Then in the Unhide dialog box > click sheet you desire to unhide
- Click Ok
Hope doing this will recover the missing data from Excel file.
The entire data is taken from: http://www.repairmsexcel.com/blog/recover-missing-sheet-tabs-microsoft-excel/?utm_source=forum&utm_medium=ref&utm_campaign=bl