Query returned more data than will fit on a worksheet

  • Thread starter Thread starter Carrie
  • Start date Start date
C

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?
 
Carrie said:
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?
Click to expand...


What version of Excel are you using? Excel 2007 has 1,000,000 rows and 16,000
columns.
 
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.
 
I was running in the wrong format, needs to be xlsx. Thank you to everyone
for your help.
 
Back
Top