Ok, I got a three sheet excel file that I cannot get to run calculation
on.

Sheet 1 has ~4000 rows, 10 columns. Each row has a VLOOKUP and two
INDEX statements.

Sheet 2 has ~8000 rows, 4 columns, the data is imported via SQL query.

Sheet 3 has ~4000 rows, 4 columns, this data is imported from a text
file.

The VLOOKUP command on Sheet 1 references Sheet 2. Each row on Sheet 1
has two INDEX statements, one statement each references Sheets 2 and 3.

When I get all the data in and try to calculate, I get to 30% then
Excel hangs, hard and forces a kill process and restart situation. All
the INDEX statments appear correct, all the VLOOKUP statements are
correct, but neither returns data that is in the referenced cells, some
come up good, some come up N/A but then, calculation never completes.

Help, I need this to work.

I did try regenerating the files by copying the template portions of
the sheet over and re-making the necessary macros and queries....


--
snobordr
------------------------------------------------------------------------
snobordr's Profile: http://www.excelforum.com/member.php...o&userid=36075
View this thread: http://www.excelforum.com/showthread...hreadid=559459