SUPPORT / SAMPLES & SAS NOTES
Problem Note 46428: "Index was outside the bounds of the array" appears when viewing details for a Microsoft Excel PivotTable that contains more than 256 columns
 |  |  |  |  |
Using the SAS® Add-in for Microsoft Office, if you open a table that contains more than 256 columns into a PivotTable and then attempt to view details, you might see the following message:
Not all source records have been copied.
Subsequently, you might receive this exception:
System.IndexOutOfRangeException: Index was outside the bounds of the array. at System.Array.InternalGetReference(Void* elemRef, Int32 rank, Int32*pIndices) at System.Array.GetValue(Int32 index1, Int32 index2) at SAS.Office AddIn.PivotTable.FormatDetailWorksheet(Workbook book, Worksheet sheet, PivotTable table) at SAS.OfficeAddIn.ExcelAddin.OnWorkbookNewSheet(Workbook book, Worksheet sheet) at SAS.ExcelAddIn.VstoExcelAddin.OnWorkbookNewSheet(Workbook Wb, Object Sh)
The exception occurs when Microsoft Excel attempts to display more then 256 columns. This is an Microsoft Excel limitation.
Click the Hot Fix tab in this note to access the hot fix for this issue.
The hot fix prevents the exception from occurring, but you will still see the Microsoft Excel message Not all source records have been copied if you exceed the 256-column limit.
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 | 4.3 | 6.1 | 9.2 TS2M0 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 6.1 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 6.1 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 6.1 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 6.1 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 6.1 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows XP Professional | 4.3 | 6.1 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Windows Vista | 4.3 | 6.1 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Windows Vista for x64 | 4.3 | 6.1 | 9.2 TS2M0 | 9.3 TS1M1 | ||