Problem Note 59263: "Object reference not set to an instance of an object" might appear when saving a Microsoft Excel file that contains SAS® content
 |  |  |  |  |
When using the SAS® Add-In for Microsoft Office, you might see the following error when you attempt to save a Microsoft Excel file that contains SAS content. Specifically, this error can occur when focus is on a chart sheet instead of on a worksheet.
Exception information
----------------------------------------------------------------------
Object reference not set to an instance of an object.
Exception Details:
----------------------------------------
Exception type: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Source: SAS.OfficeAddin
Target Site: .ctor
Stack Trace:
at SAS.OfficeAddin.CachedCubeCredentials..ctor(Workbook workbook)
at SAS.OfficeAddin.ExcelAddin.RemoveCubeCredentials(Workbook book, Boolean
startSaveWatcher)
at SAS.OfficeAddin.ExcelAddin.OnBeforeSave(Object document, Boolean saveAsUI,
Boolean& cancel)
at SAS.ExcelAddIn.VstoExcelAddIn.OnWorkbookBeforeSave(Workbook Wb, Boolean
SaveAsUI, Boolean& Cancel)
This problem can occur after you apply Hot Fix 4 to release 7.12 of the SAS add-in.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-In for Microsoft Office | Microsoft® Windows® for x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 |
| Microsoft Windows 8 Enterprise 32-bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro 32-bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise 32 bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium 32 bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Professional 32 bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate 32 bit | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 7.12 | 7.13 | 9.4 TS1M3 | 9.4 TS1M4 | ||
A fix for this issue for SAS Add-in for Microsoft Office 7.12 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y40.html#59263| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-11-01 16:13:13 |
| Date Created: | 2016-10-28 13:32:13 |