I have a workbook containing a set of worksheets containing pivot tables of various sales stats.
I wish to output this workbook on a large lcd screen TV in the sales room so that the sales team can see their stats changing dynamically through the day. I need to find a way to optimize worksheet font size to the largest possible size (both horizontally and vertically) so as to ensure that the report contents are legible to everyone in the room. I have tried playing around with autozoom but have not managed to find an acceptable solution as yet. Can anyone help?