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
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
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