Excel Input Mesage Box incorrectly sized when Windows Display Scale is set to higher than 100%

Question

Hi,

Many Excel applications I have developed for clients use the Excel Input Message (Data Validation > Input Message). This functionality displays a neat yellow box next to the selected cell instructing a user what to enter.

However, I have reived many complaints that not all text is shown and there is no way to scroll or resize. When I recently changed laptop (Running Windows 10 Pro 64-bit version 1803 and Office 365 64-bit version 1807 (16.0.10325.20036), I experience the same issue.

After some testing it seems that it is connected to Windows 10 Display Scaling (Settings > Display > Scale and layout). On computers with high DPI screens the scale must be set to a high percentage in order to make text readable on the screen. Using Microsoft Surface Book 2 with its beautiful 3000x2000 13-inch screen has 267 DPI and suggests 200% display scaling. However, when the Windows Display Scale is set higher than 100% then the Input Message box is not scaled properly and the larger text does not fit in the box. Very annoying.

Would think this is something for the Excel team to fix, right?

Have I missed any settings that can fix the problem?

Answer 1

Hi All,

This issue has been fixed in the latest version of Monthly Targeted channel, which is on version 1812 (11126.20074).

This update will also trickle down to other channels in the coming months.

Regards,

Sheen

Answer 2

Hi Intellimediase,

We tested the behavior on our end, so it should work yours. You can try it out and let us know.

Regarding a fix, we generally do not have an ETA, but we will do our best to report this to the related team as fast as possible.

Regards,

Sheen