Tuesday, August 9, 2011

Unable to view Worksheet tabs on the Microsoft Excel 2007

While I was writing a Visual FoxPro program and tried to import some data into an Excel worksheet, something strange happened.

I have noticed that the I was unable to view the worksheet, it suddenly disappear from my Excel application. Although I can see the file was still being opened, but nothing appear on the screen:-








 
 
 
 
 
 
 
I did a Google search on this and eventually I have found a solution.
 
In fact the solution is very simple:-
 
1. Launch the Excel worksheet
2. Click on View and then go for New Window, the worksheet will appear
3. Re-save the Excel worksheet.
4. Close the file and open again to ensure the worksheet is back to normal



.

No comments:

Post a Comment