No Worksheet Appears in Microsoft Excel
When you open a workbook in Microsoft Excel, you cannot see the file. There
appears only a gray screen, even if (sometimes) you can see a formula in
the formula bar!
This can happen for several reasons:
Least likely is that your workbook has hidden sheets, such as
with a personal.xls file. So, just go to FormatàSheetàUnhide.
Excel isn't really opening your workbook at all. Go to ToolsàOptions,
General tab. Uncheck Ignore Other Applications.
The worksheet has gotten hidden within the application window.
Go to WindowàArrange, and hit OK.
Note how the closing buttons appear now...
So double-click the title bar of the workbook...
And now notice how the closing buttons appear...
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved