News

Report: Office 2010 Upgrades Can Be 'Daunting'

IT organizations need to plan for Office 2010 upgrades, which may require setting up user support aids and addressing file compatibility issues beforehand, according to a December report published by Forrester Research.

The report, "Pitfalls To Avoid When Upgrading to Microsoft Office 2010," suggests that migration pains will be greatest when moving from versions earlier than Office 2007. For instance, Office 2007 shares the same "ribbon" menu system as Office 2010. Microsoft also started using its Office Open XML document format with Office 2007. Those two aspects represent big changes from earlier versions, such as Office 2003, which retains the more traditional UI and older document formats.

Personnel using earlier Office editions without the ribbon UI, such as Office 2003, may require "30 minutes to an hour of training per app" before getting up to speed with Office 2010. The report recommends setting up online training materials and wikis, among other measures, to provide such training.

IT pros may have to manually fix older files to enable compatibility with Office 2010, according to the report. In some cases, the older files may have to be recreated anew. Office 2010 and Office 2007 use the Office Open XML format for saved files, which have a four-character extension, such as ".DOCX" for Word files rather than the earlier ".DOC" extension. The report indicates that "links to files using earlier-generation extensions will break" in Office 2010.

To find files in the older document format, Microsoft offers a free command-line tool called the "Office Migration Planning Manager." However, this tool doesn't actually fix the older files. The report recommends using proprietary tools from Microsoft partners, such as those from ConverterTechnology, to automatically fix file compatibility problems.  

An upgrade to Office 2010 may affect power users who previously used add-ins in Office. They may have created in-house applications in Office using macros or Visual Basic for Applications. The VBA code will break using the 64-bit version of Office 2010, the report warns. IT pros can use another free tool from Microsoft to find such problems beforehand. The "Office Code Compatibility Inspector" tool from Microsoft will detect compatibility issues with such add-ins, but the tool can only evaluate one file at a time.

Another free Microsoft tool, "Office Environment Assessment Tool," will identify the add-ins and applications being used with Office apps. However, like Microsoft's other free tools, there's no automatic fix for incompatibility issues. The tools also can't scan password-protected files, according to the report.

Despite the potential pitfalls, organizations do appear to have upgrade plans in mind. An earlier first-quarter 2010 survey by Forrester found that 63 percent of 111 productivity professionals planned to upgrade to Office 2010. Half of the respondents without such plans said they were in the process of upgrading to Office 2007.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

Featured

  • Microsoft Appoints Althoff as New CEO for Commercial Business

    Microsoft CEO and chairman Satya Nadella on Wednesday announced the promotion of Judson Althoff to CEO of the company's commercial business, presenting the move as a response to the dramatic industrywide shifts caused by AI.

  • Broadcom Revamps VMware Partner Program Again

    Broadcom recently announced a significant update regarding its VMware Cloud Service Provider (VCSP) program, coinciding with the release of VMware Cloud Foundation (VCF) 9.0, a key component in Broadcom’s private cloud strategy.

  • Closeup of the new Copilot keyboard key

    Microsoft Updates Copilot To Add Context-Sensitive Agents to Teams, SharePoint

    Microsoft has rolled out a new public preview for collaborative "always on" agents in Microsoft 365 Copilot, bringing enhanced, context-aware tools into Teams channels, meetings, SharePoint sites, Planner workstreams and Viva Engage communities.

  • Windows 365 Cloud Apps Now Available for Public Preview

    Microsoft announced this week that Windows 365 Cloud Apps are now available for public preview. This aims to allow IT administrators to stream individual Windows applications from the cloud, removing the need to assign Cloud PCs to every user.