Monthly Archives: March 2023

Manual Calculation No Longer Viral!

Excel has 3 basic calculation modes: Automatic, Manual and Automatic except Tables. But an Excel session can currently only have one Calculation mode (unless you are using FastExcel which allows open workbooks and their worksheets to have different Calculation Modes). … Continue reading

Posted in Calculation | Tagged , | Leave a comment

Only Calculating the Active Workbook

When you have more than one workbook open Excel has always recalculated all of the workbooks at each recalculation. That can be very painful if one or more of the workbooks are slow to calculate. Now the Excel Dev Team … Continue reading

Posted in Calculation, Excel | Tagged | Leave a comment