![]() |
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