To recalculate all formulas in a massive workbook, use F9 . This acts as a "refresh" for your data processing.