+ Reply to Thread
Results 1 to 14 of 14

excel wont show the data area

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    excel wont show the data area

    hi all, my first post so please be patient.
    when i open a .xls document it looks like its frozen but its not..
    i must go to view and toggle fullscreen mode to get the data to appear.
    where the data should be it just shows the desktop untill i toggle full screen.
    can any one help please?

  2. #2
    Registered User
    Join Date
    05-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: excel wont show the data area

    further more: if i open excel first (new) then click and drag a .xls into it its fine.

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: excel wont show the data area

    This sounds like a problem with Excel. Try reparing the installation and if this fails, uninstall and re-install.
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  4. #4
    Registered User
    Join Date
    05-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: excel wont show the data area

    Ok thanks I will try a repair and I will let you know..

  5. #5
    Registered User
    Join Date
    05-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: excel wont show the data area

    Tried a repair but no success..

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: excel wont show the data area

    It sounds to me like you are opening a worksheet that is out of the viewing area. Maximize any workbooks you are viewing.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  7. #7
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: excel wont show the data area

    I agree with Marvin.

    if you could upload a picture of the first screen appearing when you load excel maybe someone can identify the issue .
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  8. #8
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: excel wont show the data area

    Hi MP, I did think of this of this and tried it, but when you escape from full-screen, the worksheet goes into hiding again. The OP says that when they toggle full-screen, it appears (or at least that is what I understood from the first post).

  9. #9
    Registered User
    Join Date
    05-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: excel wont show the data area

    thanks for the replys

    meg.jpg

    Yes abousetta if I go to tools > Full screen then Tools > full screen again all the work appears and work can be done.

  10. #10
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: excel wont show the data area

    Hi,
    Perhaps you have you system to view on multiple screens. I have two monitors and I can drag stuff to the second screen and it won't show on the one I'm working on.

    Right click on your desktop and then on Screen Resolution to see if you are using 2 displays.
    Attached Images Attached Images

  11. #11
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: excel wont show the data area

    you can also have the problem I think if the last person that saved the workbook had two screens in a different configuration
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  12. #12
    Registered User
    Join Date
    05-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: excel wont show the data area

    all pc's have one screen only

  13. #13
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: excel wont show the data area

    Quote Originally Posted by albyschev View Post
    all pc's have one screen only
    I can't respond to this without being sarcastic so I will keep my mouth shut

  14. #14
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: excel wont show the data area


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1