Tag Archives: Excel

VBA Corruption Registry Fix

Posted on February 24, 2024 by fastexcel

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 →

Posted in Uncategorized | Tagged , , | 3 Comments

Sheet Calculate Change

Posted on February 24, 2024 by fastexcel

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 cells on the selected worksheet(s), but did not marke these … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Python in Excel: Python User Defined Functions

Posted on November 6, 2023 by fastexcel

This post explores using Python in Excel to create Python User Defined Functions. The example used is a function to calculate Gini coefficients (see https://fastexcel.wordpress.com/2011/05/21/fast-gini/). Defining the UDF Python UDFs live in the workbook global Python space and must be … Continue reading →

Posted in Calculation, Excel, Python, UDF | Tagged , , , | Leave a comment

Python in Excel: Controlling Python Calculation

Posted on November 2, 2023 by fastexcel

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 Data Tables” has been renamed to “Partial”. Partial Calculation works like Automatic … Continue reading →

Posted in Calculation, Excel, Python, VBA | Tagged , , , | Leave a comment

Python in Excel: How do Excel and Python Formulas Work Together?

Posted on November 1, 2023 by fastexcel

In the previous post I showed how Python and Excel calculation methods are completely different: So when Excel formulas and Python formulas depend on one another how does this all work? Excel->Python->Excel->Python Lets look at a simple example of inter-dependent … Continue reading →

Posted in Calculation, Excel, Python | Tagged , | Leave a comment

Python in Excel: PY Calculation, Globals & Co-Volatility

Posted on November 1, 2023 by fastexcel

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 instance moving cell E5 … Continue reading →

Posted in Calculation, Excel, Python | Tagged , , , | Leave a comment

Python in Excel: Round-Tripping Gotchas

Posted on October 24, 2023 by fastexcel

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 important to distinguish between formatted Excel values … Continue reading →

Posted in Calculation, Python | Tagged , | Leave a comment

Manual Calculation No Longer Viral!

Posted on March 14, 2023 by fastexcel

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

Posted on March 1, 2023 by fastexcel

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

Excel Screen-updating Performance Comparison.

Posted on January 14, 2023 by fastexcel

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 My benchmarking workbook The workbook contains one sheet (Sheet1) with 4895 formulas and 1000 constants. … Continue reading →

Posted in Calculation | Tagged , | Leave a comment