Error: Index Out of Range

When updating CrossLinks in your report, you may get the following error message in the Status column:

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index.

Refresh Pivot Tables

This error message most often results from a Pivot Table that requires refreshing. To resolve the issue:

  1. Navigate to any Pivot Table in the Excel linking document, and click in it.
  2. On the Analyze ribbon, click the Refresh drop down menu, then Refresh All.
  3. Save and close the workbook.
  4. Re-try to update the CrossLinks. If this does not resolve the issue, please Contact Us for further assistance.