There seem to be more cases recently where the VBA in a workbook gets corrupted and is removed when the workbook is reopened. Circumstances Nobody seems to know exactly why this happens but there there do seem to be one … Continue reading →| Excel and UDF Performance Stuff
Recent builds of Excel 365 (version 2308 onwards) have introduced a change to the way Sheet Calculate (Shift-F9) works. Previously Sheet Calculate did a recalculate of all changed and volatile cell…| Excel and UDF Performance Stuff
This post explores using Python in Excel to create Python User Defined Functions. The example used is a function to calculate Gini coefficients (see Defining the UDF Python UDFs live in the workboo…| Excel and UDF Performance Stuff
Because Python calculations can be slow it is worth looking at ways of controlling Python calculation. Partial Calculation The calculation setting that used to be called “Automatic except Dat…| Excel and UDF Performance Stuff
In the previous post I showed how Python and Excel calculation methods are completely different: Python calculates Left-to-Right and Top-to-Bottom, ignoring dependencies, and when a PY calculates t…| Excel and UDF Performance Stuff
Python Calculation Python in Excel calculates all the PY cells in a workbook sheet by sheet, and row by row, starting at the top left PY cell. If you break this calculation sequence rule, by for in…| Excel and UDF Performance Stuff
Python is a full-blown programming language and so supports a rich variety of datatypes.So what happens when you move data from Excel to Python and back to Excel (Round-Trip)? Excel Datatypes It is…| Excel and UDF Performance Stuff
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 op…| Excel and UDF Performance Stuff
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. N…| Excel and UDF Performance Stuff
The time that Excel takes to refresh the screen display can be a significant factor in overall processing speed. Things that affect screen updating Time Excel only updates the visible part of the E…| Excel and UDF Performance Stuff