Excel 2010 display distortion when opening files created by Excel 2003
Dear Mircosoft/ Microsoft Community,
My company's IT Department has recently upgraded from Excel 2003 to Excel 2010.
Our office users, who now use Excel 2010, have been frequently encountering display distortion when opening files created by Excel 2003.
Screenshot of display distortion example:
Expected working display:
We are fully aware of the following temporary work-around (Cut, copy, and sort inserted objects with their parent cells):
However, the setting does not 'stay' even when we have Save the file; meaning, the next time we open the same file or another file, the advanced option 'Cut, copy, and sort inserted objects with their parent cells' will be unchecked.
Please advise what we can do about it.
Is there a patch to fix this issue?
Are there any ways to make the changes to Options stay?
Thanks in advance.
Solutions to the Problem Excel 2010 display distortion when opening files created by Excel 2003
Use the System File Checker tool to repair corrupted or missing system files:
- Click Start.
- Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
- The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
- Type or copy paste the below command line into it without quotes:
- "Sfc /scannow"
Recommended Method to Repair the Problem: Excel 2010 display distortion when opening files created by Excel 2003:
How to Fix Excel 2010 display distortion when opening files created by Excel 2003 with SmartPCFixer?
1. Download Error Fixer. Install it on your computer.
2. After the scan is done, you can see the errors and problems which need to be repaired.
3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.
Related: Cannot display online pdf files in IE8 Windows 7 asus com How do I run program written for Windows 95 asus support Intermittent connection issues with Windows 7 using Airport wireless router www asus com Problems with Windows Store and other apps Verification Code Email Password asus motherboard drivers Start Menu Windows Explorer has Stopped Working asus driver Windows 7 Ultimate computer seems to stop HD head seeking chkdsk no error asus motherboard drivers Windows Programs crash upon opening asus driver download If you are a common consumer of Microsoft Windows OS and your computer is running Windows 7 or Windows 8.1, you may have been annoyed by the Get Windows 10 nagware/scumware/malware. Now the nagware will annoy more people. Recently Microsoft again has changed the rules of the get Windows 10 for free. It announced that some business PCs running the professional editions of Windows 7 and Windows 8.1 would soon begin seeing the get Windows 10 notifications pop up to ask users to update to the newest Windows 10.,Microsoft Office Outlook 2007 Has Delay In Opening Folders,Is It Possible To Enable 4gb On 32 Bit?,Which Programs Can I Uninstall To Reclaim Space,Windows 7 Slow Shutdown And Auto Restart,Epson Stylus 5500
Read More: Troubleshooting:What button should l press on WinRAR(evaluation copy) window open? Error,How to Fix Error - Excel 2007: Can I SUMIF ( ) by cell colors??,Fast Solution to Error: Fsx Incompatible with windows 7??,Tech Support: Help - Headings picking up Word default lists!,How Can You Fix - how can i fix a slow running laptop?,STARTUP ERROR MESSAGE!,Language pack Windows 7,Trying to do a 2 axis chart,W7U-64 not allowing System Restore Points - Event 8193 VSS, Error 0x80042306,ie:can not connect to server. si could be disconnected