Speed Up MS Query update

E

efreedland

Office Excel 2003
Setup:
I am using ODBC to download data from a backend database into my
spreadsheet.

The number of rows is upward of 10k and the number of adjoining
formula columns is 39. "Fill down formulas in columns adjacent to
data" is turned on. The operation is run multiple times as needed by
the logic within the workbook.

Problem:
The operation of updating query, subsequent to the first time, is very
slow.

Comment:
I assertained that turning off "Fill down formulas in columns adjacent
to data" option speeds up the operation significangly suggesting that
the execution of deletion and filling of the adjacent columns is the
bottleneck.

Question:
Is there a way to speed up the operation without losing the
functionality?
 
K

Keith74

Is it possible for for when you import the data to the spreadsheet to
have the screenupdating turned off?
 
E

efreedland

Is it possible for for when you import the data to the spreadsheet to
have the screenupdating turned off?
Click to expand...

Application.ScreenUpdating = FALSE is already in place.
 

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

Similar Threads

After checked condition, add the data to adjacent cell automatically 9
execution speed issue when closing files 5
Is there a way to speed up Calculation !!!!!!!!!!!!!!! 4
Fill column adjacent to external query (Excel 2007) 0
VBA speed up 0
Speed up macro 3
Filling adjacent formulas with data import 1
my incomplete macro to fill in 8000 rows - pls help 5

Top