Query returned more data than will fit on a worksheet

[Carrie]

I am trying to run a query using other Data Sources, when I run it says query
returned more data than will fit on a worksheet. Is there any way to get
around this so I can get all the data?

 

[Glenn]

I am trying to run a query using other Data Sources, when I run it says query
returned more data than will fit on a worksheet. Is there any way to get
around this so I can get all the data?

What version of Excel are you using? Excel 2007 has 1,000,000 rows and 16,000
columns.

 

[Carrie]

I am using 2007 but it is ending w/ 65,536.

What version of Excel are you using? Excel 2007 has 1,000,000 rows and 16,000
columns.

 

[IanC]

I haven't used XL2007, but if the file you are using is compatible with
earlier versions it will be restricted to 65536 rows (and 256 columns). The
file needs to be XL2007 format to enable data beyond this range.

 

[Carrie]

I was running in the wrong format, needs to be xlsx. Thank you to everyone
for your help.

 

[Dave H]

You could try dumping the data to a pivot table

I am using 2007 but it is ending w/ 65,536.

:
-