Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Window will not maximise (Excel 2002)

    In Excel the sole worksheet window is in the 'independent' pane mode (as it would be if windows were tiled). I cannot get it out of this state.

    Clicking the 'maximize' button toggles it bigger and smaller, always retaining a maximize button (there is never a 'restore down' button). It remains as an independent window.

    Any clues?
    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    Andrew O

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Window will not maximise (Excel 2002)

    Have you tried the universal fix. Quit and restart the computer?

    Is this on ALL worksheets (old ones, new ones you just create), or just this one? It could be some code running in the background on this sheet. Was the worksheet created by you or did you get it from someone?
    Steve

  3. #3
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Window will not maximise (Excel 2002)

    Steve

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Thanx for the interest.

    Yes - it happens for all spreadsheets {new; old; small;big}, after all restarts.

    Since I posted, I totalled removed the whole of the Office XP application and reinstalled it.
    Fascinatingly, it remembered all my old settings (why am I unsurprised) and is still exhibiting the problem.
    My home machine is an XP multi-user machine and the problem always occurs on my account - not others.
    My current theory it is some registry Key related to my profile. System restore is my next planned trick.

    Andrew O

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Window will not maximise (Excel 2002)

    Check out <!post=this post ,132721>this post <!/post> from pieterse for things to try.

    HTH

    Peter

  5. #5
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Window will not maximise (Excel 2002)

    Peter

    Thanx - a really useful set of information. I can report some interesting facts but no solution yet.

    Running Excel in /safe mode fixes the problem but /automation doesn't. I removed all XLB's on my system and that hasn't helped either.

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

    Re: Excel Window will not maximise (Excel 2002)

    Hmmm. strange problem indeed.

    Maybe regegistering may help?:

    Start, run,
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Unregserver

    followed by

    Start, run,
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Window will not maximise (Excel 2002)

    Folks
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    I've appreciated all the help. The problem is now fixed!

    I discovered that after the re-install Office wanted to do some strange 'installing' every time it ran.
    To cut a long story short, I eventually discovered that it only happend for my login code, and not for the rest of the family's.

    Accordingly, I created a new user code, and blew away the old one.
    <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

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

    Re: Excel Window will not maximise (Excel 2002)

    Great you're up and running again!
    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
  •