Excel opens in small window

Question

Every time I open Excel it opens in a tiny window where no data is even visible.  It dosen't matter what I do or how I save it, it opens back up in the at tiny window the next time I open it.  I am having this issue constantly with several workbooks and occasionally with some others.  None of my workbooks consistently open in a full window.

Answer 1

Use this in the codemodule of the ThisWorkbook object of your Personal.xlsb: If you don't use a Personal macro library, create one by starting to record a macro and choosing to store the macro in "Personal macro workbook" and Excel will create it for you.

Private Sub Workbook_Open()

    Application.ActiveWindow.WindowState = xlMaximized

End Sub

Answer 2

Hi Blake,

Have you tried Bernie's suggestion? @Bernie, thanks for sharing.

If this behavior persists after that, could you provide some information for us to investigate:

1. Your detailed Office version and Office version. (Open Word>File>Account>Product information, provide your subscription and version)
2. Could you capture a screenshot of the tiny window?
3. Since you mentioned it occurs with specific workbooks, is there something special in that workbook? (e.g. VBA)  Please copy the content to a new workbook to see the outcome.
4. Regarding other workbooks which the issue occurs occasionally in, is there a regular pattern? For example, if you test 10x, will the issue occur only 2 out of 10 times?
5. Did Excel work properly previously, if so, did you make any changes like updating or installing some software?

Regards,

Zixuan

Answer 3

Blake,

re: small window when workbook opens

This sounds similar to the problem that can occur when your workbook has a UserForm that contains a RefEdit control.

Translated that means: the workbook, at some point, displays a box and requests you select some cells.

There are some possible fixes, but the best solution is to not use the control...

'---

Jim

https://goo.gl/IU\*\*2  (Dropbox)

<PII has been removed by forum moderator>