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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2012-02-11T14:29:34+00:00

    You have to open excel, maximize it, then lcose it. It will only open maximized if it was last clsoed that way. Annoying, itsn't it?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-02-12T03:07:52+00:00

    Dear sh,

    If I open excel and maximize and save and close, it'll not remember the maximize.

    The only way for me is open excel, use mouse to expand each side to fit to the screen and save, then it remember "nearly maximize", but not fully maximize like click maximize.

    Any help?

    THank you.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2012-02-12T23:00:14+00:00

    As was posted earlier in this thread, the sure-fire fix is:

    Try this workaround: place the following code in PERSONAL.XLSB, in ThisWorkbook:

    Private Sub Workbook_Open()

    Application.WindowState = xlMaximized

    End Sub

    With that, even if Excel opens in a window, it will maximize itself.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2012-02-13T06:53:46+00:00

    Dear EdHans,

    Thank you for your reply.

    Please kindly explain how can I place that code?

    I'm newbie.

    Thank you.

    Was this answer helpful?

    0 comments
  5. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2012-02-13T08:15:09+00:00

    You have to create a personal workbook first. Have a look at this side, especially the section "How do you create the file if it does not exist:"

    http://www.rondebruin.nl/personal.htm

    After you create your personal workbook, place the code into the codemodule "ThisWorkbook" in that file.

    Andreas.

    Was this answer helpful?

    0 comments