Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GETSQL Is too slow
I love using the GETSQL function within an excel worksheet
to easily retrieve data from an access database. The function is easy enough so that non technical personnel can modify it when they see fit. The problem is that when you have too many getsql functions on a worksheet, the worksheet takes a long time to recalculate. Any ideas?? If not then i'll just use traditional ado with parameter boxes contained on the worksheet to retrieve data. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow Tab | Excel Discussion (Misc queries) | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
Why Del is Slow | Excel Discussion (Misc queries) | |||
Why so slow | Excel Discussion (Misc queries) | |||
Slow VBA, Can someone please look at it? | Excel Programming |