ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Querying Large Database (https://www.excelbanter.com/excel-discussion-misc-queries/247250-querying-large-database.html)

RussellT

Querying Large Database
 
I have large workbooks that I query data from one sheet to the next based
upon defined criteria. When the workbooks are small using 10,000 to 15,000
rows, the application works okay, but when I use larger datasets 50,000 to
60,000 rows the application locks up all the time. This doesn't happen to me
when the same workbook is opened in Excel 2003. Any ideas as to what's going
on?


All times are GMT +1. The time now is 02:49 PM.

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