We faced below strange issue with MS excel 2013 -
Problem
* Select a .xlsx and open the file .
* No error displayed , but the file worksheet does not get opened.
* However other files able to be opened
* So suspect was whether file was corrupted.
Solution attempted -
- Open Excel , Under File -> Open - Browse the file to be opened , select the option while browsing to "Open & Repair" instead of just open
- Above message is popup . Select Repair option to correct any errors
- If it does not work try out Extract Data option to recover possible data
In our case unfortunately the first option wasn't lucky and we recovered data through extract data option. Hope its useful to some worried minds !!