Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2007

Tip: Looking for answers? Try searching our database.

Unable to View Contents of Workbook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Thomas M. - 27 Dec 2007 00:49 GMT
Excel 2003

This is a weird problem that I've never seen before.  We have a user who is
unable to view the contents of a specific Excel workbook.  When the user
opens the file it looks as if there are no files open--all he gets is a gray
screen with the menu and toolbars.  The name of the file does not appear in
the title bar and there are no sheet tabs at the bottom of the screen
either.  So it looks like no file has been opened.  But there are some
telltale signs that the file IS actually open.  The Name box shows "A25" and
the Formula box shows the value of that cell, and those values change as the
arrow keys are used, showing that the cursor is moving around in an open
spreadsheet even though the cursor itself cannot be seen.  The Font box
displays "Arial" and the Font Size box shows "12," and finally hitting the
Print Preview button shows the entire contents of the spreadsheet.  So the
file is definitely open, but it looks like nothing is there.

Other people are able to view the workbook without any problems, so I know
that it's not a problem with the workbook, and the user can view other
workbooks just fine, so it would seem that the problem is not with his Excel
installation.  There are no macros in the workbook, and no locked, hidden,
or protected cells.  The fact that even the sheet tabs at the bottom of the
screen cannot be seen rules out the "background color is the same as the
font color" problem.

The user reports that he was able to view the workbook up until last week,
at which time he "hit something" and he has not been able to view the file
since.  Of course, he has no idea what he hit.

I'm stumped.  Any help will be greatly appreciated!

--Tom
Jim Rech - 27 Dec 2007 01:14 GMT
Sure sounds like the workbook window has been moved off screen.  Press
Ctrl-F7 and use the arrow keys (num lock off) to move the screen left and/or
up until it comes back into the Excel window.

Signature

Jim

> Excel 2003
>
[quoted text clipped - 28 lines]
>
> --Tom
Thomas M. - 27 Dec 2007 16:10 GMT
Yep, that was the problem.  I had a copy of the file and was trying to
reproduce the problem working from just a screen print and a phone
conversation, without any luck.  Another tech got a look at the machine this
morning and realized that the file was minimized and was off the bottom of
the screen.

Thanks for the CTRL+F7 tip!  I did not know that one.

--Tom

> Sure sounds like the workbook window has been moved off screen.  Press
> Ctrl-F7 and use the arrow keys (num lock off) to move the screen left
[quoted text clipped - 32 lines]
>>
>> --Tom

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.