How to fix Microsoft Excel files containing Korean Text or Web Korean Text files can be read or open correctly on korean characters encoding (save as xls, xlsx, csv, txt, or web files)

By: Revengsky Joseph D. Reyes (a.k.a rjdreyes – jcyberinux.com)

1. Download and Install – Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 file.

2. Change the Regional and Language Options, Go to Settings > Control Panel > Regional and Language Options > then from there click Advanced tab then at drop-down box choose language version of the non-Unicode you preferred. (e.g. Korean)

Note : At Code page conversion tables drop-down, you may also check the boxes for your preferred language (e.g. Korean tables – MAC-Korean, etc…)

3. Still at the Regional and Language Options, click on Languages tab, at Supplemental Language Support, click the boxes for (Install files for complex script and right-to-left languages) and (Install files for East Asian Languages)

Note : (On Install files for East Asian Languages) – If there’s a check and the check box were disable, just ignored it, else then enable it by checking the box.

Click also on the Details button, at Text services and Input languages, you can add specific input language support for your keyboard.

Then click at Advanced tab, at Compatibility Configuration, click (Extend support of advanced text services to all programs). Then click Ok. Then click Apply. Then it will ask for you to restart. Just restart your computer.

4. Open MS Excel 2007, click on Excel 2007 Main Menu Options (MS office Logo on it), click Excel Options, then at Popular Tab, go to Personalize your copy of Microsoft Office, then from there, click Language Settings…

At Primary editing language, choose language you preferred (e.g. Korean). Click Ok. Then Reload or restart MS Office 2007. 😀

I hope this tutorials helps you out! 😀

Related Entries / Articles / References / Links:
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats – Official Site