August 19, 2019
I'm having trouble with excel reports I've made holding their formatting when sending to others in the office via email.
They are getting #### in columns or titles are moving to the next line, when from my perspective what I'm viewing and saving it looks correct? How can you hold the formatting so that it looks the same when they open it - besides sending a PDF?
In this example the column width I have is 9.27 (109 pixels) whereas when opened on my colleagues computer it is only 9.14?
I've been using excel for many years and this is the first time I've been faced with this problem... I'm feeling like a rookie!
Any advice will be much appreciated?
Screen shot example attached (the 'y' and 'g' are going on the next line)
July 16, 2010
December 7, 2016
First I want to share a link to a page that describes how column width is determined in Excel.
Now some questions.
1) What file format is used? The old .xls or the new .xlsx format?
I have seen similar posts where this issue occurs with .xls format but not with .xlsx.
2) Does all users have the same font library? In case a non-standard font is used.
3) If none above makes any difference and in regards to font issues, do test with changing the default printer.