max query result size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there some place to set the maximum number of rows returned by a query?
One of the resons I upgraded to Excel 2007 was the row limit increase. but I
just ran a query and the data cut off at row 65536. I know there should be
about another 20K rows.

Peter Richardson
 
Unless my old .xls file was renamed to the new 2007 extensions (.xlsm or
..xlsx), my old .xls function formulas did not work (even though 1 million
rows displays).

Perhaps it is the same issue with you?
 
That was the thought that snother discussion made me think of yesterday but I
can't test it until tommorrow at work. Excel 2007 won't let me save-as when
accessing remotely so I have to get be in the office to resave.

I'll let you know tommorrow if this solves it
 
Yes this turned out to be the solution. Since the sheet was opened in
compatability mode it had to remain compatable. Saving as xlsm, closing and
reopening allowed the right resultss to be returned.
 

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

ADOBE Connection to open Excel workbook 3
Row limit in Excel 3
Query not returning all the rows 8
Macro formula array return limits? 4
Determining Max value in a dynamic range 3
macro to calculate average on varying sized rows with missing valu 4
Figuring out MAX LEN in a given column 2
CopyFromRecordset Question 4

Back
Top