Web Excel file too large to download to one sheet

C

cary

I am attempting to download an Excel file from the web that has around 480
columns. When I try, I get message that states that it is too large and it
only displays one sheet with the standard 256 columns. How can I solve this
and get all of the information?
 
C

chemist

Try downloading only part of it at a time. Afterwards you can connect all the
columns together. However, you can only get 256 columns across Excel-- that's
all there are. If there are less than 65536 rows, you could try transposing
the database.....
 
Top