Same spreadsheet displays different column widths on different computers.

Jeff Geiselman
Jeff Geiselman used Ask the Experts™
on
I have a spreadsheet that needs to be saved as a .PRN file, which makes the column widths critical as that determines how many spaces are between columns of the .PRN file.
When I open this file on one computer it says Column A column width = 17.  
When I open this file on another computer it says Column A column width = 16.9.  
Both computers are running Windows 7 and Excel 2010.
The spreadsheet has data in 9 columns (A:H) and each column has a slightly different width.
This column width difference changes the .PRN file by 2 Space characters.  This causes problems to another program that reads this .PRN file because the field columns are in different positions than expected.
Both Excel 2010's are using the same default 'Body Font' and Font Size 11.  The 'Office' Theme is common to both using Cambria & Calibri.
What setting or configuration is causing the one Excel Column widths to be different?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
Do you have any workbook file in the start up folder?
Is the desktop resolution the same on both Win 7 computers? I've seen this cause different display issues in the past, but I'm not sure if it's still a thing or not.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Another thought would be the default printer.  Do they both have the same default printer assigned?

mlmcc
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

IT Tech Assoc
Commented:
I checked the Display Screen Resolutions on the two PC's.
1st PC was at 1600 x 900.
2nd PC was at 1680 x 1050.  The column differences still persisted after changing to 1600 x 900, so I changed it back to 1680 x 1050.

However when checking the screen resolution, I noticed that the 'Personalize- Display menu 'Text' size was different.
1st PC was at 'Smaller - 100%'    (9 point Segoe UI at 96 pixels per inch)
2nd PC was at 'Medium - 125%' (9 point Segoe UI at 120 pixels per inch)
(See also 'Set custom text size (DPI)' option on left side of 'Display' window)
I changed the 2nd PC to 100% and relogged back into the computer.  Then when I opened up the spreadsheet and checked the column widths, they were the same as the 1st PC!
Thank you 'Echo_S' for pointing me to the 'Display' settings configurations.  Although the resolution was not the issue, it allowed me to identify the 'Text' sizing differences which was the issue.
I will test this on a few different PC's to see if the results are repeatable.
Thanks for suggestions!
Example of Display 'Text' size differences that causes column width differences
PS:  the files in the 'XLSTART' folder were the same and the default printers were the same.
Glad to hear you found the culprit!
Jeff GeiselmanIT Tech Assoc

Author

Commented:
'Echo_S' pointed me in the right direction, but 'Resolution' was not the problem.
The actual solution was 'Text' size differences, which I documented in my comment for clarification.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial