Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel file opens blank (2003 SP3)

    One Excel file opens blank for a user. When print preview is selected the file contents display normally. When sent to me the file opened normally so I am trying to find something about the file or the user's configuration to explain this. While poking around the client discovered if he opened an older version of the file side by side with the new file, he states both displayed the file contents normally.

    I had the client use the built in Excel file repair but there was no difference.

    Before we went through the "Systematic Troubleshooting", since it is only one file, I thought I'd ask if anyone has seen this type of behavior in just one file?

    -Jester
    I know enough to know I don't know enough

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel file opens blank (2003 SP3)

    Has the user tested whether the problem persists after restarting the PC?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file opens blank (2003 SP3)

    Yes.

    -Jester
    I know enough to know I don't know enough

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel file opens blank (2003 SP3)

    This type of problem is very difficult to investigate. I'd let the user try Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post> anyway. Even if it doesn't solve the problem, it'll rule out some possible causes.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file opens blank (2003 SP3)

    What happens if he/she does Window, arrange, tiled?

    Might be the file was saved on a dual screen setup with the file window showing on the second monitor?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file opens blank (2003 SP3)

    Bingo!

    Though off for the strangest of US holidays, Columbus Day, I emailed the fellow who was dealing with this issue and although he had recreated the file based upon the previous version he replied that, "Yes", he does have a dual monitor configuration and when the windows were arranged as suggested he was happy as a clam. He even said he'd pay more attention to the dual monitor impact if ever this type of scenario appeared in Excel or other apps.

    Thanks for the detective work!!

    -Jester
    I know enough to know I don't know enough

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file opens blank (2003 SP3)

    Excellent, I love a solved mystery!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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