Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2016 formatting problem

Status
Not open for further replies.

EliseFreedman

Programmer
Dec 6, 2002
470
GB
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top