Web Excel file too large to download to one sheet

G

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What makes a Large File in Excel? 3
i want to open large file 300 col, how to split between worksheets 5
Number too large for excel 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Large Operation Error 0
my excel file is too big 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Import text file into Excel 2007 then copy sheet to another workbo 2

Top