no, 256 is the limit.

you may be able to use ms query to 'query' the data source and select
only the colums you need, or to build separate queries that return the
data over multiple sheets