View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carrie Carrie is offline
external usenet poster
 
Posts: 68
Default Query returned more data than will fit on a worksheet

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

"Glenn" wrote:

Carrie wrote:
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.