You could try dumping the data to a pivot table
Quote:
Originally Posted by Carrie
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.
|