Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Auto-complete too slow when worksheet has 10.000 rows
Hi,
I'm doing a Excel 2007 VSTO template where I load a worksheet with between 10.000 to 15.000 rows of data, and was counting on using the built-in excel cell auto-complete to speed future data entry. Nevertheless I noticed the auto-complete is very slow, it takes a couple of minutes for excel to, after starting to edit a cell, be able to finish the "internal scan" of all the upper cells in other to be able to find a match. Is there anything I can do to speed it up? Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto complete | Excel Worksheet Functions | |||
How do I auto complete a cell with text from another worksheet? | Excel Worksheet Functions | |||
Auto Filter With Auto Complete Ability | Excel Discussion (Misc queries) | |||
AUTO COMPLETE FOR CELL VALUES | Excel Discussion (Misc queries) | |||
Vlookup did cell auto formating but not displaying complete text.. | Excel Worksheet Functions |