Fix Excel problem with data connections. Index was out of range. Must be non-negative and less than the size of the collection.Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: startIndex

Job ID: 32911423

Budget: $10 – $30 CAD

It is not a specific file error but ANY files that require data connection with a table in current workbook.
New files and old files have same error. Blank file with a selection of data table in same file return same error.

Only quote if you experienced this issue or if you know exactly what to do to resolve this issue

an exception was thrown by the type initializer for: 'Microsoft. AnalysisServices.XmlaClient'
an exception was thrown by the type initializer for: 'System.Net.ServicePointManager'
an exception was thrown by the type initializer for: 'System.Net.ComNetOS'
Index was out of range. Must be non-negative and less than the size of the collection.Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: startIndex
Related categories: Visual Basic .NET Data Processing Excel C# Programming