There are 35 sheets of approximately 100 columns and 120 rows of vlookups.

"Niek Otten" wrote:

Please post your formulas. Is the data sorted? What values are you looking
for? How big are the ranges?

For good advice on performance (especially for lookups), visit

www.decisionmodels.com


--
Kind regards,

Niek Otten

"Emom" wrote in message
...
I have a lot of vlookups and I have tried everything. The data is one the
same workbook, the data is copy past value so that it isn't tying to
anything. I don't have any links on this sheet, but sometime it takes
20-40
minutes to calculate. It doesn't tie up the machine, but it shouldn't
take
that long