Hello,

I have created an excel spreadsheet which creates labels, it functions very well. The only issue I have encountered is when trying to use the file on different computers. The format changes...... It is critical that excel is used because the file relies on many formulas to control the entries in specific cells.

I have found the screens DPI has a very large effect. I can replicate the results found on other machines by matching the DPI used on that specific computer.

File was created on a 4k screen running at 175% scaling (168 DPI). When opened on a computer 1600x900 100% the page layout is roughly .5" too short. The 4k screen is nearly impossible to use at 100% as everything is microscopic....however for debugging purposes I have changed my screen to 100% (96 DPI) the files behavior is exactly replicated as other machines which the file is roughly .5" too short. The file is designed in inches using the page layout view and each line has a specific height........ I am not sure if there is some type of vba work around that can be implemented?

The label sheet uses 20 (1"X4" Labels) It is critical everything prints correctly. This file needs to be able to print consistently on different computers as it is not acceptable for professional use.

This issue seems to be related to a bug in how microsoft excel calculates inch height in page layout. It works perfectly at 175% (168 DPI). On the same computer at 100% (96 DPI) it ends up about .5" too short and at 350% (Not sure what DPI this is) the file ends up roughly .4" too long.....