It is possible to have multiple releases of SAS Add-In for Microsoft Office installed on your computer at the same time. Here are some examples:

• You might use SAS^® Add-In for Microsoft Office 2.1 to access SAS^® 9.1.3 content.
• You might use SAS^® Add-In for Microsoft Office 4.x and SAS^® Add-In for Microsoft Office 5.1 to access SAS^® 9.2 and SAS^® 9.3 content.
• You might use SAS^® Add-In for Microsoft Office 5.1, SAS^® Add-In for Microsoft Office 6.x, SAS^® Add-In for Microsoft Office 7.x, and SAS^® Add-In for Microsoft Office 8.x to access SAS 9.2, SAS 9.3, and SAS^® 9.4 content.

However, only one release of SAS Add-In for Microsoft Office can be in use at a time.

In addition, the different releases of SAS Add-In for Microsoft Office can be used with only the versions of SAS software that support it, as shown in the following table.

SAS^® System Support for SAS^® Add-In for Microsoft Office

SAS Add-In for Microsoft Office	SAS Software Release
	9.1.3	9.2	9.3	9.4
2.1	yes	no	no	no
4.x	no	yes	yes	no
5.1	no	yes	yes	yes*
6.x	no	yes	yes	yes
7.x	no	yes	yes	yes
8.x	no	yes	yes	yes

*  In order for SAS Add-In for Microsoft Office 5.1 to work with SAS 9.4, the latest hot fix must be applied.

Switching between Different Releases of SAS Add-In for Microsoft Office

Note: There is a caveat to using the Switcher Utility in a shared environment. For example, be careful when using the utility in a Terminal Server environment or a Citrix XenApp environment that presents Microsoft Office. Using the Switcher Utility in this environment affects all other Microsoft Office users.

To switch between SAS Add-In for Microsoft Office releases 2.1, 4.x, 5.1, 6.x, 7.x, and 8.x, use the Switcher Utility executable.

Note: Administrator privileges are required for using the Switcher Utility.

The default location for the SwitcherUtility.exe file varies depending on the release. For example, this is the location for the 4.3 SwitcherUtility.exe:

Always use the Switcher Utility of the latest (most current) release of SAS Add-In for Microsoft Office that is installed. For example, if you have both SAS Add-In for Microsoft Office 4.3 and 5.1 installed, then you would use the SAS Add-In for Microsoft Office 5.1 Switcher Utility because it is the latest release in the example. If you upgrade to a later release of SAS Add-In for Microsoft Office and keep earlier releases installed, then be sure to use the Switcher Utility for the latest release.

Each SAS Add-In for Microsoft Office release 4.x and later contains information in the online Help. To access the relevant online Help information, use the following steps. Note that this example is for SAS Add-In for Microsoft Office 4.3.

1. Start Microsoft Office by starting Excel, Word, or PowerPoint.
2. In the application, click the SAS tab.
3. Click Help and select Help for SAS Add-In for Microsoft Office Help.
4. Click the Index tab.
5. Enter switching and press the Enter key on your keyboard.

Within the online Help, see the Getting Started section called "Managing multiple installations of the SAS add-in."

Using the Different Releases of SAS Add-In for Microsoft Office

• Use SAS Add-In for Microsoft Office 5.1 and 6.x and 7.x and 8.x to access SAS 9.2, SAS 9.3, and SAS 9.4 content.
• Use SAS Add-In for Microsoft Office 4.x and 5.1 to access SAS 9.2 and SAS 9.3 content.
• Use SAS Add-In for Microsoft Office 2.1 to access SAS 9.1.3 content. If you attempt to use SAS Add-In for Microsoft Office 4.x or later to access SAS 9.1.3 content, the following error occurs:

Error Text

A portion of Show Details contains the following:

If you attempt to use SAS Add-In for Microsoft Office 2.1 to access content in SAS 9.2 or later, the following error occurs:

Error Text

Additional Information

For more information about command-line usage, see SAS Note 38700, "Command-line usage with the SAS^® Add-In for Microsoft Office Switcher Utility."