April 21st, 2004, 3:25 pm
Even after you have optimised the sheet calculation sequence by renaming the sheets there are still speed gains to be had by merging sheets, particularly with VLOOKUP.Also the need to optimise the sheet calculation sequence has lessened significantly with excel 2002 and excel 2003.for more info on excel calculation speed see Optimising Speed