Hi!

I was wondering if any one knows what the max that Excel 2002 can handle in terms of Vlook ups, formulas, and how large the file can be until it's unstable and eventually crashes. I have a 36MB excel file with about 200+ Vlook ups in a column and a few hundred columns of formula's this 36MB excel file is going out over the network to another 30MB file to calculate vlook ups. It sits on the excel file for hours for the vlook ups to populate. Does anyone have a solution to this issue or has ever seen it? Would there be a better solution like using Access for this?
Help Please..

I have used about 2000 vlookups without any problems. So not sure if this is the problem. I think 30Mb for an excel file is large. But it depends on how complex your formulae are - this could be the problem especially if you are using dynamic ranges. Problem with access is that calculations are not as easy as excel, but it is good at data sorting. are your vlookups static, in which case you could populate these cells with code.