In cell G2 I have the following formula:

=INDEX('[Database -- AR and EQ.xls]Stock
Lookup'!$G$2:$G$6000,MATCH($B2,'[Database -- AR and EQ.xls]Stock
Lookup'!$B$2:$B$6000,0),1)

I other columns (H through Q), I have similar formulas but linking to
different closed workbooks.

When 'Database -- AR and EQ.xls' is closed, the formula is much longer than
the one posted above because it references folders on the hard drive:

=INDEX('U:\SC\Research\Other\Hot List\Hot List Database\[Database -- AR and
EQ.xls]Stock Lookup'!$G$2:$G$6000,MATCH($B2,'U:\SC\Research\Cap ital IQ\Hot
List\Hot List Database\[Database -- AR and EQ.xls]Stock
Lookup'!$B$2:$B$6000,0),1)

I have a macro that will pull down this formula about about 6000 rows. I
have similar formulas in other columns. Then excel copies and pastes the
values.

As you can imagine, updating these links from the closed workbook takes a
very, very long time. Opening the "Database -- AR and EQ.xls" workbook
before refreshing the links probably won't work for me because a commercial
add-in I need to use interferes with the open process for some reason.

I'm wondering if there is a faster way to update the data than this? I
don't necessarily need to pull down and copy paste value the formulas; I just
need the data in the right place based on the cell references the formulas
refer to.

Thanks for thinking about this.

SteveC