Excel 2002 Problem
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?