Microsoft pulls buggy Office 2010 January updates

Microsoft's preparations for a new Japanese era coming later this year break Excel.

Microsoft has pulled its first updates of the year for Office 2010 after reports, mostly from Japan, that they have been breaking Excel. 

The updates arrived on January 2 with changes in the Japanese calendar, most likely to reflect the changes coming with the end of Japanese Emperor Tenno Akihito's reign. He is planning to abdicate on April 30, 2019, marking the end of the Heisei era and ushering in an as yet unnamed new calendar era. 

As reported by Borncity, Microsoft pulled the January 2019 Office 2010 updates on January 5. All updates for Excel 2010 and Office 2010 included "changes to Japanese calendar". 

Japanese language blogs have reported that after installing the non-security updates, users were seeing messages that 'Excel cannot be opened' and that the spreadsheet app was sometimes freezing. Excel also couldn't handle new entries in cells. Users reported that uninstalling the updates resolved the issue.  

Microsoft's support note for the Excel 2010 update confirms it has been removed due to problems the update causes in Excel. 

"After you install this update, you may experience difficulties in Microsoft Excel or other applications. To resolve this, uninstall the update by following the instructions in the 'More information' section," Microsoft says

SEE: 20 pro tips to make Windows 10 work the way you want (free PDF)

Microsoft has previously written about the inter-era calendar bugs that could surface during and after the change in Japanese emperors. 

The company described it as "The Japanese Calendar's Y2K Moment", referring to the chaos expected as computers, which only used the last two digits to indicate a year, failed to distinguish between the years 2000 and 1900.  

"The magnitude of this event on computing systems using the Japanese Calendar may be similar to the Y2K event with the Gregorian Calendar," wrote Microsoft's Shawn Steele. 

"For the Y2K event, there was world-wide recognition of the upcoming change, resulting in governments and software vendors beginning to work on solutions for that problem several years before January 1, 2000.  Even with that preparation many organizations encountered problems due to the millennial transition."

Steele noted that after the era has changed it will be too late to test for compatibility problems. Microsoft included a special registry in the Windows 10 version 1803 to help developers spot problems before the change. 

There are all sorts of cross-era data problems that could occur during and after the transition. At transition, software with calendar controls that presume only one current era could stumble. Also, how will algorithms handle the same date expressed differently in two eras?

Previous and related coverage

Microsoft: Crash-causing Outlook 2010 security patches are now fixed

Microsoft's new Outlook 2010 update ought to provide the critical security fixes without the crashes.

Microsoft: We've pulled buggy Outlook 2010 patches over crashes

Flawed updates cause Outlook and other apps to crash.

Microsoft's Office 2019 price hike: Will it push you to Office 365?

Microsoft follows through with its plans to raise Office 2019 prices by 10 percent.

Microsoft Office malware: Banking trojan downloads if you hover over PowerPoint hyperlink

Malware gangs add mouse-hover downloads to their arsenal of social engineering tricks to infect PCs.

Microsoft boosts Office productivity with AI for Word and other features TechRepublic

Microsoft 365 got a number of upgrades this month aimed at increasing user productivity and focus.

Microsoft unveils its new Office app for Windows 10 CNET

The app will act as a hub for all your Microsoft Office needs.