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

A fix for this issue for SAS Add-in for Microsoft Office 4.305 is available at:

A fix for this issue for SAS Add-in for Microsoft Office 4.3 is available at:

A fix for this issue for SAS Add-in for Microsoft Office 4.305 on SAS 9.3 is available at:

A fix for this issue for SAS Add-in for Microsoft Office 5.1 is available at:

A fix for this issue for SAS Enterprise Guide 5.1 is available at: