Querying Large Database

R

RussellT

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?
 

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

Top