Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
max query result size
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
max query result size
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? -- Thx MSweetG222 "barnabel" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
max query result size
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 "MSweetG222" wrote: 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? -- Thx MSweetG222 "barnabel" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
max query result size
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. "MSweetG222" wrote: 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? -- Thx MSweetG222 "barnabel" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace ^ in web query result | Excel Worksheet Functions | |||
Replace ^ in web query result | Excel Programming | |||
Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
Formula Result Won't Query | Excel Discussion (Misc queries) | |||
put query result into variable | Excel Programming |