Update 19-Sep-2019: Unfortunately this continues to be an issue for some users and unfortunately there is currently no solution from Microsoft except to suggest the use of compatibility mode as detailed below. We have requested this be fixed, so please up-vote it at https://officespdev.uservoice.com/forums/224641-feature-requests-and-feedback/suggestions/38632276-support-for-high-dpi-taskpanes
Update 27-Jun-2018: Although we have a fix for this issue on an internal build, it appears that Microsoft Office version 1807 (which is currently only available on the Office Insider track) fixes this issue. The missing user-interface problem was caused by a bug in Microsoft Office 1805/1806 updates. We will release our fix shortly, but the 1807 version update will also become available to everyone over the next month or so. If you want to get it immediately see How to get Office 365 insider builds.
Microsoft has recently released updates to both Windows (the April 1803 update) and Microsoft Office 2016 to provide support for multiple monitor high DPI (dots-per-inch) displays.
In the early days of Microsoft Windows, monitors were assumed to have 96 DPI and all applications worked on that assumption: with a user interface fixed on that assumption. In the last 15 years, monitors with higher DPI have started to appear with the benefit that on-screen text and graphics look much smoother because there are so many more dots per inch. That caused problems for many applications which were fixed to assume 96 DPI, causing their user interface to scale improperly on high-DPI monitors. Applications like Analyse-it supported high DPI monitors and adjusted their user interface appropriately... until now.
These days many of us have 2 or more monitors hooked up to a PC as it's a much quicker and more efficient way to work. Often these monitors are different sizes and often have different DPI, and the recent changes to Windows and Microsoft Office are designed to address varying DPIs. Instead of applications scaling their user-interface to one system-wide DPI setting, they now scale according to the monitor application is displayed on. If you have the latest updates to Windows and Office, and drag the Microsoft Excel main window between monitors with different DPIs you will see the application user interface rescale properly for the monitor.
This is a major new improvement and under the hood there are some major changes to Microsoft Windows to support it. Unfortunately, as with all major changes to Windows, it breaks some existing applications, especially add-ins like Analyse-it that are at the mercy of what the host application (Microsoft Excel in this case) decides to do with respect to user interface scaling. In the case of Analyse-it, when the new multiple monitor DPI awareness feature is enabled in Microsoft Excel 2016 the Analyse-it user interface does not appear properly in the task panes.
We are now working on a fix for this issue, but in the meantime, if you are experiencing this problem follow these steps to temporarily disable multiple monitor DPI awareness in Excel:
We will update this blog post when we have a fix available.
Comments are now closed.