SUPPORT / SAMPLES & SAS NOTES
Problem Note 54320: Slicers that are used in a SAS® Financial Management read-only report or data-entry table might stop working
 |  |  |  |  |
In SAS Financial Management, slicers that are used in a data-entry form or a read-only report might stop working if the data-entry form or the read-only report is designed to use a large number of slicers. This problem has been reported in situations where up to 15 slicers are defined for a read-only report. In some cases, Microsoft Excel also fails.
When this problem occurs, the following error is written to the SAS® Add-In for Microsoft Office log:
09-09-2014 10:09:54,855] --------------- EXCEPTION REPORT --------------- [09-09-2014 10:09:54,890] Failure while trying to refresh NewTable0. [09-09-2014 10:09:54,912] System.Runtime.InteropServices.COMException (0x80020009): The index into the specified collection is out of bounds. at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) at Microsoft.Office.Interop.Excel.Shapes.GetEnumerator() at SASSESExcelAddIn.TableController.removeAllCommentIndicators() at SASSESExcelAddIn.TableController.onRefresh(RefreshOptions refreshoptions) at Com.Sas.Ses.OfficeIntegration.View.FormElement.refresh(RefreshOptions refreshoptions)
If you encounter this error, contact SAS Technical Support.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |
| Microsoft Windows 8 Enterprise 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows 8 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows 8 Pro 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows 8 Pro x64 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Pro | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Pro 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 R2 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 for x64 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 Datacenter | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 R2 Std | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 Std | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Windows 7 Enterprise 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Windows 7 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Windows 7 Home Premium 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Windows 7 Home Premium x64 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Windows 7 Professional 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Windows 7 Professional x64 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Windows 7 Ultimate 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Windows 7 Ultimate x64 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| 64-bit Enabled AIX | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| 64-bit Enabled Solaris | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||
| Linux for x64 | 5.4_M1 | 5.5 | 9.4 TS1M3 | |||