Update: The trouble-shooter can now make the necessary changes for you, so if you're experiencing this problem and are unsure what to do simply run the trouble-shooter to fix the problem.
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.
Let us know your comments, opinions and any questions you have on this post. Your feedback is always appreciated.