ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Refreshing database query in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/206070-refreshing-database-query-excel.html)

nc

Refreshing database query in Excel
 
When I refresh the query I get this message

"The query returned more data than will fit on the worksheet"

The results returned are no more than 2000 rows.

Please advise.

Thanks.


John Bundy

Refreshing database query in Excel
 
Too many columns?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"nc" wrote:

When I refresh the query I get this message

"The query returned more data than will fit on the worksheet"

The results returned are no more than 2000 rows.

Please advise.

Thanks.


nc

Refreshing database query in Excel
 
There are only 5 columns.


"John Bundy" wrote:

Too many columns?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"nc" wrote:

When I refresh the query I get this message

"The query returned more data than will fit on the worksheet"

The results returned are no more than 2000 rows.

Please advise.

Thanks.



All times are GMT +1. The time now is 10:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com