Problem Note 42141: Bar chart encounters errors opening results in Microsoft Excel using the SAS® Add-In for Microsoft Office
When opening a bar chart or graph results from the SAS Add-in for Microsoft Office, you might receive an error message similar to the following:
"Bar Chart" encountered errors while opening the results: Cannot insert object.
Here are a few suggestions for resolving this error:
- Make sure that the ActiveX control can open by checking your Trust Center options. To check these settings, click the Microsoft Office button, and then click Excel Options. In the left-hand panel, select Trust Center. On the right, click the Trust Center Settings button, and then select ActiveX Settings. You can try selecting a less restrictive ActiveX option.
- Still in the Trust Center Settings, select Macro Settings, and then select the Trust access to the VBA project object model option.
- Make sure that when you installed Office you performed a full install. Alternatively, if you performed a custom install, make sure that you selected to install the Office Shared Features.
Operating System and Release Information
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2008 for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
| Windows Vista | 4.2 | | 9.2 TS2M0 | |
| Windows Vista for x64 | 4.2 | | 9.2 TS2M0 | |
*
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.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-01-31 16:03:52 |
| Date Created: | 2011-01-20 16:25:33 |