Same spreadsheet displays different column widths on different computers.

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?
LVL 1
Jeff GeiselmanIT Tech AssocAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamMicrosoft Excel ExpertCommented:
Do you have any workbook file in the start up folder?
Echo_SCommented:
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.
mlmccCommented:
Another thought would be the default printer.  Do they both have the same default printer assigned?

mlmcc
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Jeff GeiselmanIT Tech AssocAuthor 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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Echo_SCommented:
Glad to hear you found the culprit!
Jeff GeiselmanIT Tech AssocAuthor 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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.