Excel 2016 formatting problem

[EliseFreedman]

I am experiencing a really tricky problem and I am hoping I can explain it in a way that makes sense. We have recently been upgraded to Office 2016 at work. I am creating a workbook that is going to be shared with many different people. I have spent days formatting the workbook so that it is neat and tidy and properly formatted etc. I sent it out to the stakeholders for review and one has come back totally ripping it to pieces saying that there are loads of tabs where he cant see the full questions etc. Ive gone into it today on my screen and its perfect. Did a screenshare with a different colleague and some tabs are fine for her and others are cutting off the text. It appears that every different machine displays the workbook differently. On my computer it looks perfect but clearly thats not the case for everyone. I am not sure if this is a solveable problem with code (or any other method of formatting) or if it is unavoidable. Any suggestions are more than welcome because i dont know where to begin to resolve it

 

[Andrzejek]

We usually are not very crazy about images of how your Excel looks like, but in this case it would be helpful to see what you have. One image: how does it look like when it looks OK, and another one with the 'wrong' look.

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[EliseFreedman]

I have sorted it

I have protected the worksheets whilst allowing the user to change the size of the rows. That way they can alter them as needed without destroying the formulas

 

[strongm]

This can often be down to differing printer drivers ...