Home > Unexpected Error > Unexpected Error Occurred In Sas Add-in For Microsoft Office

Unexpected Error Occurred In Sas Add-in For Microsoft Office

Note: Crystal Xcelsius works with Excel.exe in the background. Or, in Microsoft Windows 7, click START and type REGEDIT in the search box. With this method, the Team Explorer is still installed, but it does not load in Excel. The AMO.dot should be present in the Checked items are currently loaded box. navigate here

When you click the details of the error, the following statements might appear: System.ArgumentException: Input string is not in valid format for decryption at SAS.Shared.SASCrypt.Decrypt(String inString) at SAS.OfficeAddin.Options.OptionsCore.LoadSmtpPassword() at SAS.OfficeAddin.Options.OptionsCore.Read(String fileName) Save the file in the SAS Add-In for Microsoft Office installation directory, which is typically C:\Program Files\SAS\Add-In for Microsoft Office. Note: If you do not have a SAS.OfficeAddin.dll.config file, you can create one by using a text editor. Type:Usage NotePriority:lowTopic:System Administration ==> InstallationDate Modified:2006-01-04 14:56:36Date Created:2005-11-10 11:26:55 This content is presented in an iframe, which your browser does not support. http://support.sas.com/kb/16/466.html

If you are using Office 2007 In Word 2007, click the Office button, then Word Options, and then Add-ins. Select File ► Exit. OPTION 3 This method requires testing to determine the optimal number records to view on your machine. Option 2 Do not uninstall Team Explorer, but change the load behavior in the Windows registry. Sign in Create Profile Welcome [Sign out] Edit Profile My SAS Home Resources Support Learn Connect Knowledge Base Products & Solutions System Requirements Install Center Third-Party Software Reference Documentation Papers

In one case, the error did not occur with 25 records. The details of the error are as follows: System.NullReferenceException: Object reference not set to an instance of an object.at SAS.OfficeAddin.CommandBarManager.InstallUI() An additional error might appear: System.Runtime.InteropServices.InvalidComObjectException: COM object that has been Please report this error to your site administrator. If you are using Office 2010 Open Microsoft Office Word, select File ► Options, and then click Add-Ins on the left.

Operating System and Release InformationProduct FamilyProductSystemProduct ReleaseSAS ReleaseReportedFixed*ReportedFixed*SAS SystemSAS Add-in for Microsoft OfficeMicrosoft® Windows® for x644.35.19.2 TS2M39.3 TS1M1Microsoft Windows Server 2003 Datacenter Edition4.35.19.2 TS2M39.3 TS1M1Microsoft Windows Server 2003 Enterprise Edition4.35.19.2 TS2M39.3 Please report this error to your site administrator. You can turn the load behavior back on when you need the TEAM menu item again. imp source With Team Explorer installed and loaded, begin to replicate the problem again with SAS data sets, such as sashelp.cars, but before you click the OK button in the View SAS Data

all these words this exact wording or phrase one or more of these words or or Don't show information containing... Change the number from 3 to 2 and click OK. You might also receive errors just by opening a text file in Excel when both Microsoft add-ins are loaded: Unexpected exception occurred in SAS Add-in for Microsoft Office. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins.

  • SAS is not responsible when you edit the Windows registry: changes in the Windows registry can render your system unusable and will require that you reinstall the operating system.

    To
  • any of these words Results per page 10 25 50 100 Sign in Create Profile Welcome [Sign out] Edit Profile My SAS Home Resources Support Learn Connect Subset Results
  • any of these words Results per page 10 25 50 100 Sign in Create Profile Welcome [Sign out] Edit Profile My SAS Home Resources Support Learn Connect Knowledge Base
  • Go to Start>Settings>Control Panel>Add Remove Programs. 2.

any of these words Results per page 10 25 50 100 Knowledge Base > Samples & SAS Notes Type Select Type Installation Note Problem Note Sample Usage Note Sign in http://support.sas.com/kb/34/019.html There are three possible workarounds for this issue: Option 1 Uninstall Team Explorer by using Add/Remove programs. Operating System and Release InformationProduct FamilyProductSystemProduct ReleaseSAS ReleaseReportedFixed*ReportedFixed*SAS SystemBase SASMicrosoft® Windows® for 64-Bit Itanium-based Systems9.21_M39.2 TS2M3Microsoft Windows Server 2003 Datacenter 64-bit Edition9.21_M39.2 TS2M3Microsoft Windows Server 2003 Enterprise 64-bit Edition9.21_M39.2 TS2M3Microsoft® Windows® To view the RateIT tab, click here.

Warning: Always back up your registry before you make any registry changes. check over here An unexpected exception error might occcur with SAS® Add-In for Microsoft Office.Type:Installation NotePriority:mediumDate Modified:2011-06-01 15:15:31Date Created:2010-12-23 14:07:11 This content is presented in an iframe, which your browser does not support. all these words this exact wording or phrase one or more of these words or or Don't show information containing... If it is not present, click Add, then browse to the installation path for the SAS Add-In, select AMO.dot, and click OK.

In the Templates and Add-ins dialog box, click the Templates tab. Edit the SAS.OfficeAddin.dll.config file to include the following content. < configuration > < assemblySettings > < add key="ExcelReportXMLRawData" value="false"/ > < /assemblySettings > < /configuration> Save your changes, restart Excel, and For assistance, see Windows Help, Microsoft documentation, or the Microsoft Windows Web site. his comment is here Launch the SAS Software Navigator from the SAS Software Navigator CD (located in Section 801, Deployment Tools Media, from the Media Storage section, of the SAS 9.1.3 installation binder). 4.

If so, you can avoid this error by rearranging your Excel tables or changing the growth behavior of the data view on the Advanced tab of its Properties dialog. So the number was increased to 50 records but still no error occurred. To view the RateIT tab, click here.

Please report this error to your site administrator.

Sign in Create Profile Welcome [Sign out] Edit Profile My SAS Home Resources Support Learn Connect Knowledge Base Products & Solutions System Requirements Install Center Third-Party Software Reference Documentation Papers Change the output type from SAS Report to HTML. To view the RateIT tab, click here. Reason: A list cannot overlap another list.

Go to the "CD Software Index" and choose to reinstall the "SAS Configuration Wizard" and the "SAS Add-In for Microsoft Office". (The SAS Add-In for Microsoft Office is in the "SAS Sign in Create Profile Welcome [Sign out] Edit Profile My SAS Home Resources Support Learn Connect Subset Results by: Resources (2) Support Learn Connect Standard Search Advanced Search Results Filter This may be due to another Excel table partially overlapping the same horizontal or vertical plane as the data view whose size is changing. weblink The AMO.dot should be present in the Checked items are currently loaded box.

System.IndexOutOfRangeException: Index was outside the bounds of the array..... In the Manage drop-down list, select Word Add-ins and click Go. To view the RateIT tab, click here. Please report this error to your site administrator.