
Power Query
Power Pivot
Power BI

August 19, 2019

Hello!
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?
Thank you
Maree
Screen shot example attached (the 'y' and 'g' are going on the next line)

VIP

Trusted Members

December 7, 2016

Hello,
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.
1 Guest(s)
