Installation Note 44788: The error "System.Xml.XmlException: Root element is missing" might occur when Microsoft Office is invoked
The following error message might be displayed when you invoke Microsoft Office with SAS Add-In for Microsoft Office installed.

Clicking the Details button shows additional information, as shown below.

The error might occur because of a corrupt AMOOptions.xml file. In that case, renaming the AMOOptions.xml file should correct the problem.
- Close Microsoft Office.
- Browse to the following location depending on your operating system and rename the AMOOptions.xml file to AMOOptions_old.xml.
- Windows XP path to AMOOptions.xml, where X is the version of the SAS Add-In installed:
C:\Documents and Settings\<userid>\Application Data\SAS\Add-InForMicrosoftOffice\X
- Windows 7 and later path to AMOOptions.xml, where X is the version of the SAS Add-In installed:
C:\Users\<userid>\AppData\Roaming\SAS\Add-InForMicrosoftOffice\X
Note: The paths shown above use the default Windows profile path for the respective operating system. Your Windows profile path might be different. If your profile path is other than the default, open My Computer and enter %appdata% in the address bar to determine what your Windows profile path is.
Operating System and Release Information
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.305 | 6.1 | 9.2 TS2M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.305 | 6.1 | 9.2 TS2M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.305 | 6.1 | 9.2 TS2M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Standard Edition | 4.305 | 6.1 | 9.2 TS2M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 for x64 | 4.305 | 6.1 | 9.2 TS2M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2008 for x64 | 4.305 | 6.1 | 9.2 TS2M0 | 9.3 TS1M2 |
| Microsoft Windows XP Professional | 4.305 | 6.1 | 9.2 TS2M0 | 9.3 TS1M2 |
| Windows Vista | 4.305 | 6.1 | 9.2 TS2M0 | 9.3 TS1M2 |
| Windows Vista for x64 | 4.305 | 6.1 | 9.2 TS2M0 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The error "System.Xml.XmlException: Root element is missing" might occur when Microsoft Office is invoked after the SAS® Add-In for Microsoft Office has been installed.
| Type: | Installation Note |
| Priority: | medium |
| Date Modified: | 2011-11-28 13:25:24 |
| Date Created: | 2011-11-03 09:26:13 |