[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


Maximized View Upon Opening Excel 2010

Posted on 2014-02-20
Medium Priority
Last Modified: 2014-02-21
Excel.exe I have, opens in minimized view as default. If then a Book1.xlms is saved with the code:

Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub

in Sheet1, the new default becomes Maximized when opening it, as desired.

Is there a way to open Excel.exe itself Maximized as default without saving it as a separate workbook?
Question by:judico
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
LVL 22

Expert Comment

ID: 39875487
Try right-clicking the Excel icon you use to launch Excel.
Choose Properties.
In the Run dropdown, choose Maximized.

Author Comment

ID: 39875606
I did that but Excel.exe still doesn't open Maximized. Even when I maximize it when open and then close it, the followup opening still isn't maximized.
LVL 22

Accepted Solution

Dreamboat earned 300 total points
ID: 39875665
Try opening in safe mode. Hold the shift key while you open it. If that doesn't work, see if you can find personal.xlsb file in (I think) C:\Users\Default\AppData\Roaming\Microsoft and move it. Must close Excel first.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 39875690
Safe mode did it. I'm on a MacBook Pro, so i had to depress simultaneously fn-control-shift. After double clicking a message appears asking if I'd like to open the program in safe mode. I couldn't find the file personal.xlsb, however. First, there's no folder C:\Users ... Tried to search for it but no such file was found.
LVL 22

Expert Comment

ID: 39875701
Well, if safe mode did it, then you don't need to find the xlsb. You may not have one.

Author Comment

ID: 39875777
It still however is minimized when opening it normally.

Author Comment

ID: 39875834
Now, here's a workaround. Excel.exe still opens minimized but then I extend it manually to look as if it's maximized. Upon closing and then reopening it, the new size is retained. I know that's not the solution sought for but may be used temporarily until we find the real one.

Author Closing Comment

ID: 39876889
I guess that's the best that can be done with the current version of Excel.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question