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: Newest
Most helpful Newest Oldest
  1. 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
  2. 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
  3. Anonymous
    2010-06-28T12:26:59+00:00

    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

    Was this answer helpful?

    0 comments
  4. 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
  5. Anonymous
    2010-06-25T18:34:56+00:00

    Alas, that doesn't do it. After some further research it appears that there is a bug in Excel 2010 -- if you use a personal file, as in prior versions, to store macros, and keep it in the xlstart directory so the macros are available when you start Excel, and start by calling excel.exe then Excel won't open maximized. Not even if you jump through all the hoops that worked on prior verson of Excel. There's been enough complaining about this issue, I was hoping someone had a fix or at least notion that MS was working on the prob in an update.

    sh

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments