Question: "Occasionally in Excel, I have a table open but it isn't visible. I know the table is open because the name bar tells me it is in cell A1, etc., and the formula bar tells me what is in that cell, but the screen is completely gray. You cannot see the table. I can move from cell to cell with my arrow keys, but I cannot see the table or cells on the screen. The only way to view the table is in full screen mode, which doesn't have the task bars available. Does anyone know what the problem is and how to fix it?" - Diana
This is not a frequent problem in Excel, but not unheard of either. There could be several reasons why it’s happening. I noticed it after I started running both Office 2003 and Office 2007 on the same machine. According to some of the Excel expert message boards, a later automatic update of Windows XP or Office may have fixed my problem. There are also recurring themes of Mac Office and dual monitor usage making this a nuisance. After combing the expert message boards, here are several things to try:
1. First, make sure you are running with all current Service Packs. Visit Microsoft.com for more information. If you are using a version of Office older than 2003, you may no longer be getting any bug fixes. So, a more current version is recommended.
2. Open another workbook or two and then switching the active workbook by clicking on the Window menu bar item. Some users have reported that this “eventually” straightens out the problem.
3. Click on Window, then Arrange and choose Tiled. Be sure Windows of active workbook is selected. Maximize one of the windows. Close the others (if any) that are also open. You’ll see these on the Window drop down menu after tiling them.
4. Click on View, then Zoom and change the Zoom setting to 99%.
5. Click on Format, then Row and Unhide, then Format, Column and Unhide. This will make sure rows and/or columns haven’t been accidently hidden.
6. Also, try Format, Sheet, Unhide. If it’s grayed out, it’s not hidden.
If you have also been having this problem, let me know which if any of these worked for you. (By the way to recreate the appearance of the troubled screen, I switched to Page Break Preview, navigated away from cells with any data, then clicked on Tools, then Options and removed the the checkmark from the Row and Column headers checkbox. Just in case you have to “reproduce” the look for your support staff.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/13615/excel-help-i-have-a-table-open-but-it-isnt-visible "