Stiebel Eltron
asked on
How to resolve excel text format change when opening file in Windows 10?
Dear EE experts,
We would like to ask on How to resolve excel text format change when opening file in Windows 10.
Here's the case, we have several excel files that are done in Excel 2007, then if we're opening it in Excel 2013 / Windows 7 OS, everything's normal, everything looks the same, nothing change.
But when the same file opened in Excel 2013 / Windows 10 OS, the look of the text changed. It becomes bigger that makes it larger than the table. But opening the file with Excel 2013 & Windows 7 OS, no problem...
We found several problems that happens only with Windows 10 OS, but when it's Windows 7 OS, all files are normal...
Any incompatibility issues?
Kindly advise on how to resolve this case...
Thank you!
We would like to ask on How to resolve excel text format change when opening file in Windows 10.
Here's the case, we have several excel files that are done in Excel 2007, then if we're opening it in Excel 2013 / Windows 7 OS, everything's normal, everything looks the same, nothing change.
But when the same file opened in Excel 2013 / Windows 10 OS, the look of the text changed. It becomes bigger that makes it larger than the table. But opening the file with Excel 2013 & Windows 7 OS, no problem...
We found several problems that happens only with Windows 10 OS, but when it's Windows 7 OS, all files are normal...
Any incompatibility issues?
Kindly advise on how to resolve this case...
Thank you!
Very likely the DPI settings for fonts are changed on W10, e.g. to 125 or 150%, since the resolution is higher. Which release is that W10? Latest (1703, released in April)?
ASKER
Yes, it's W10 latest one...
Actually the resolution is 100% (looking at Excel). But the screen resolution is 1920 x 1080, but still have problem...
Any solution on this matter?
Actually the resolution is 100% (looking at Excel). But the screen resolution is 1920 x 1080, but still have problem...
Any solution on this matter?
You need to look in the display properties for the font zoom factor. The Excel zoom is (almost) irrelevant here.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great! Thank you so much!
You're Welcome Stiebel! Glad I was able to help.
I cannot see how anything of what Shums posted should apply. W10 does not use compatibility settings for Office 2013 by default.
ASKER
Oh sorry! Shums first post help resolved the problem... We're in a hurry that's why I didn't check which one is it...
That comment https:#a42264424 is exactly what seems to be totally unrelated. It is about whether you can open certain very old Excel formats.