Before you blame Excel, check whether your formulas are scanning a million empty rows.