Excels are not maximizing

[itresearcher007]

Hey all,

We are having an issue where the Microsoft Excel files are opening not fully maximized, i.e there will be small gaps on the top and the ‘Maximize’ icon will be enabled.
The excel will be maximized to the full display only after clicking this icon, and when the subsequent excels are opened, it will also not be fully maximized, with a gap between the second and the first excel slightly more then the one between the first excel and the desktop ( ref picture below). As and when multiple excels are opened, the gaps create an overlapping effect.

Please see this for the screenshot reference.

The issue is intermittent and have occurred to multiple users when opening excels from local PC and also from a shared path. We are using Excel 2013 and 2016 and have tried excel repair, re-install, cache deletion. Further, the below have also been tried

1. Manually maximize the excels, then save them so hoping it will auto-maximize the next time

2. Registry changes to force maximize all excels as suggested here

3. Deleting the ‘pos’ registry subkey value as shown in this video

4. Adding the below VBA macro to the PERSONAL.XLSB file present in ‘XLSTART’ folder in Excel’s appdata roaming

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

5. Modifying the ‘excel options’ via registry (HKCU\Software\Microsoft\Office\16.0\Excel\Options)

6. Pressing ‘Ctrl’ when opening the excel.

Specifications:
MS Excel 2013 and 2016
Windows 10 21H2
16 GB RAM
Antivirus: Sentinelone Singularity Control

No recent changes were done in the PCs before issue started.
We do not have any active add-ins in Excel and also not using any plugins. (We have already disabled the ‘Team’ add-in of the screenshot and checked).

Any help or advice in resolving the issue is greatly appreciated.

Thanks

[Rod-IT]

Office 2013 and W10 21H2 are both 2 years out of support, with Office 2016 ending support in October this year.

I would suggest your initial fix is upgrading to supported platforms.

You’ve had answers to why this happens here Excel not getting fully maximized. Seems to only '90%' maximize - Microsoft Q&A so I wont go over that again.

The short answer is, it’s by design.

[naveenkatikam]

Step 1. Press the Windows + R key combination to wake up the run window. Then type regedit in the text box and press Enter.

Step 2. When you see the User Account Control window, select the Yes option to continue.

Step 3. In Registry Editor, navigate to the following location depending on the Office version:

• Excel 2016/2019: Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel
• Excel 2013: Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel
• Excel 2010: Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel

Tips:

To check the Excel version, you can open an Excel spreadsheet and click File > Account. In the right panel, you can get the Excel version under Product Information.

Step 4. In the left panel, right-click the Options key and click Delete from the context menu.

Step 5. In the Confirm Key Delete window, select the Yes option to complete this task.

[jollybgood]

Hardware acceleration can cause display rendering issues, including incorrect window sizing. On Excel, go to File > Options > Advanced and in Display, check Disable hardware graphics acceleration and click OK, and restart Excel.

High DPI or scaling issues can make windows to appear offset,
Right-click the desktop and select Display Settings, and set Scale and layout to 100% or more, make sure the display resolution matches the monitor’s native resolution.
Open Excel, maximize a workbook, save, close, and check.

[itresearcher007]

@jollybgood

or scaling issues can make windows to appear offset,
Right-click the desktop and select Display Settings, and set Scale and layout to 100% or more, make sure the display resolution matches the monitor’s native resolution.
Open Excel, maximize a workbook, save, close, and check.

@Rod-IT @naveenkatikam @jollybgood

Thank you for the responses we shall check and try those out and let you’all know.

That said, we haven’t made changes to the display resolution or the scaling so not sure how the issue got triggered in the first place.

[Rod-IT]

The only advice I offered was upgrading, you shouldn’t be using unsupported products anyway.

I also confirmed what you are seeing is how these versions of Office work.

This is expected behaviour.

[itresearcher007]

@naveenkatikam

he Optio

We have checked this already as mentioned in Point.5 of our question. It didn’t work.

[ich-ni-san]

I know this is obvious, but I didn’t see it mentioned in the original post.

Have you tried setting the run option in the properties of the shortcut used to launch Excel?