Forum Discussion
Excel not displaying content consistently across versions. Please Help.
46 views and no helpful answers? Someone must know something that might be helpful.
The default font for the labels is different between the versions.
This will always be different unless you want to invoke a macro when the workbook opens.
OPTIONS\GENERAL. Use This as the default font. & Font size.
Also, this would be the same reason the Ribbons are not pinned in both screenshots. It is not controlled by the workbook, but a user option for each installation.
Brian Spiller thanks for the constructive input but unfortunately I don't understand what you're saying. But I do know that the default fonts are the same across all 3 versions so that can't be it. That was the first thing I checked.
LordJay777 First time I've looked at it. I can't explain why nobody else has given you an answer, but I'll share with you the question that kept running through my head as I read your post, and that's this:
WHY is it so important that it display identically on different computers?From what you say, there's no actual problem with the information; is that right? (OK, the columns are too narrow for one of the displays, but that's still not a matter of inaccuracy of information, failure for Excel to do what it's supposed to do....you can just make the columns wider for everybody.)
So, frankly, it sounds like you're making a bigger issue out of this than it warrants, unless you can say a bit more of WHY it is such an issue. Presumably you're doing this for people who can zoom in or out, scroll around to see the info. It could be that you'd be better off with a different layout, so you're not trying to squeeze so much---graphic PLUS tabular data---into the same display. But help us help you by saying a bit more of the WHY it matters.
mathetes It doesn't matter the "Why", that's not your concern. Your help should not be contingent on "why" I need it. But if you absolutely NEED a why in order to help then here goes.
In order for image 3 to be viewed the same as the first two changes have to be made, THEN when saved and shared with the OTHER two people it changes THEIR view and then they have to make adjustments to view it properly and it's all an unnecessary back and forth of making changes that should not have to be made.
To reiterate, EVERYONE viewing the document needs to have the same exact view when they open it.
Hope that helps.
Well, I apologize for offending you with the question, LordJay777. You and I may approach problem solution differently. I often find that asking "Why" helps get at the underlying objective or purpose, at which point it sometimes (not always) becomes clear that there's another way altogether to meet that purpose.
So I'm not sure yet that I understand your underlying need, but it sounds like you have various people viewing the information (including the chart) in some kind of sequence, possibly entering new information, which then makes changes....and going through multiple iterations of these steps. Is it the case that if the displays are different that one or the other might be missing a key component and therefore might misunderstand or misinterpret what they're seeing?
What I was trying to suggest with some of my other questions was based on the observation that you've got a LOT of information on that screen, in all kinds of forms--visual and tabular...so I was wondering whether changing the way it's displayed might in fact be a more effective solution. If that's not possible for some reason or other, so be it. And perhaps I asked prematurely, but I was looking to get some "thinking outside the box" going.....
Best wishes...
