Excel won't open maximized

Anonymous
2010-06-25T12:40:51+00:00

Tried setting the starup icon properties to start maximised. Tried setting registry entry HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options\Maximized to 0x00000003

All to no avail. I've sen the prob reported on lots fo other forums but it's always the solutions noted aboive that are suggested, and jsut as reported on those forums, they don't resolve the issue with Excel 2010.

sh

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

46 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-06-25T19:32:25+00:00

    Grasping at straws here since I don't have 2010, but one thing that works in some applications is to:

    • open,
    • maximize,
    • then hold the Shift key down while clicking the close button.

    Works (usually) for IE (XP and Vista), and has worked for XL2007 on Vista for me

    Was this answer helpful?

    90+ people found this answer helpful.
    0 comments
  2. Anonymous
    2010-06-25T18:13:51+00:00

    The following works for me.

    Open the file. Maximize it. Then close it. Open it again and it will be maximized.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2010-06-28T15:34:49+00:00

    Am 28.06.2010 14:26, schrieb shieber:

    <meta http-equiv="Context-Type" content="text/html; charset=utf-8"> Thanks for the suggestion. It too fails to fix matter. Seems to especially stubborn in Excel 2010. Apparently if you open a hidden personal file to load macros, you will never get a maximized Excel on startup in the 2010 version. Guess we wait for the SP1 and see what happens. sh

    If you load a personal file why did you do not maximize the application by your own?

    Andreas.

    Private Sub Workbook_Open()

      Application.WindowState = xlMaximized

    End Sub

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  4. Anonymous
    2010-06-28T15:46:44+00:00

    The personal macro workbook is hidden by default, choose View, Unhide.

    Note: you do not need to view the spreadsheet to be able to modify the macros, just press Alt+F11, you will see the file displayed on the top left as Personal, expand its Module folder and double-click any Modules

    If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  5. Anonymous
    2010-06-28T17:11:32+00:00

    No, not a command line switch, jsut the propert setting for the icon -- right click any icon, select Propoerties,  and you'll see a setting called "Run" which allows yo to set for Maximized, NOrmal, of Minimized. It works for most programs, but not Excel 2010.

    sh

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments