Results 1 to 4 of 4

Thread: Opens wrongly

  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opens wrongly

    A s/sheet on which I last worked about a month ago will not open correctly. It is offset on the Excel desktop, about 1" to the right of Excel's left margin and about 0.2" down from the lowest toolbar. Nothing - like attempting to drag or resizing enables me to get the spreadsheet properly onto my screen. It is printing OK. It was created and last saved on this PC. What's the problem - and what's the fix?
    Thanks,
    Peter

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Opens wrongly

    Try Window, Arrange, Tiled and see if you can then regain control. If that does not work check Tools, Protection and see if the Workbook has any protection, and if so hope it has no password.

    Andrew C

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opens wrongly

    That was fast!
    Unprotecting and reprotecting did it.
    Very odd - it has never happened to me before. Is it a known bug for which there is a patch?
    Thanks for saving my hide! Peter

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Opens wrongly

    It's not a bug (in Excel) that I am aware of. Normally if you cannot manipulate a window it is because of some form of protection, which may have been applied unwittingly.

    Andrew

Posting Permissions

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