Worksheet connection does not import beyond column IU

Question

I am trieng to use a worksheet connection to import data from one workbook into another workbook. Only when i refresh the data it does not go beyond colum IU (255 columns).

I know this can be an issue when using older Excel formats but both files are MS Excel 2013 files, does anybody has an idea how i can fix this?

Answer 1

The file format is irrelevant - it will be a limitation of whatever provider you are using for the data connection. Many of the standard ones - including all the ones native to Office as far as I am aware - will not return more than 255 columns from a table.