Column widths changing between users.

Question

Hello. The issue is one user opens a template xls file. They fill out predetermined fields, and click a button that organizes all the information together for easy export to another file format. At this point, the first user saves and sends the file to another user. When this user gets the file, column widths are not formatted properly and he has to manually edit each one to the correct diminsions. When the original user and I open the file, we both see the proper field widths. It seems so odd to me that we can all open the same file but see it 2 different ways. How do I fix this for the second user?

Answer 1

It's literally the column width that is changed. When you right click column A and view column width, his reads 4.89 when it needs to be 5.0 (which shows on my machine and the original user).

We are 3 people, 2 seeing it the right way, and one person opening the exact same file and seeing it differently. Same save file.... Makes no sense IMO. I'm sure there's some wacky thing causing it, hopefully someone out there knows what it is.

Answer 2

...for easy export to another file format...

Just checking... the file doesn't get turned into a *.csv file at any point does it?  All the formatting would be lost in that case.  Just a thought.

Some other ideas... do you all have the same screen resolution?  Are you all viewing the file at the same zoom level in Excel?  Zooming out can sometimes lead to text not fitting in a column when once it did...

Cheers

Rich

Answer 3

Any takers on helping me solve this issue?

Answer 4

Yes. We are in separate offices using different printers

Answer 5

Any difference in default printers?

Gord