Context menus might not fully populate in SAS® Visual Analytics Add-In for Microsoft Office 8.2 or later


Pop-up context menus might not populate in the SAS Visual Analytics Add-In for Microsoft Office 8.2 or later. If a SAS®9 Metadata Server is available, connecting to the SAS Metadata Server first might correct this issue.

Beginning in the SAS® Add-In for Microsoft Office 8.3 Update 1, there is a configuration option, ConnectToMetadataServerOnStartup, that forces a metadata connection during SAS Add-In initialization. This option applies to the SAS Visual Analytics Add-In for Microsoft Office 8.3 Update 1 as well.

To use this option, edit the SAS.OfficeAddIn.dll.config file using a plain text editor. This file is located in the SAS Visual Analytics Add-In for Microsoft Office installation directory. Add the ConnectToMetadataServerOnStartup key, making sure to match the casing exactly. For the value attribute, enter true.

Here is an example:

<configuration>
<assemblySettings>
<add key="ConnectToMetadataServerOnStartup" value="true"/>
</assemblySettings>
</configuration>