Log In
Register
Home
Power Query
Power Pivot
Power BI
August 19, 2019
Offline
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)
July 16, 2010
Offline
Hi Maree,
It could be lots of factors contributing to the resizing e.g. screen resolution, zoom level etc. which are out of your control. I would just take a screenshot and paste it as an image if you don't want it resized.
Mynda
VIP
Trusted Members
December 7, 2016
Offline
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)
