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
Hello,
When I select a data connection from table in current workbook it throw an error.
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: startIndex
It only do this when I select data from workbook. Selecting data from other sources does not triger this error and work fine.
Anyone have an idea on how to fix this issue?
Excel 2016
Whatever excel file that require data connection from table from current workbook return this error. Previously I did not have this error so I think a file corrupted and made problem.
However, unable to recover from this error from new and old files.
Anyone know this error and know how to resolve?
Sorry for the screenshot Excel is in French.
When I select a data connection from table in current workbook it throw an error.
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: startIndex
It only do this when I select data from workbook. Selecting data from other sources does not triger this error and work fine.
Anyone have an idea on how to fix this issue?
Excel 2016
Whatever excel file that require data connection from table from current workbook return this error. Previously I did not have this error so I think a file corrupted and made problem.
However, unable to recover from this error from new and old files.
Anyone know this error and know how to resolve?
Sorry for the screenshot Excel is in French.