Why don't my functions recalculate when reloading PyXLL? – PyXLL

Reloading PyXLL won't cause Excel to recalculate automatically.

The easiest way to recalculate everything after reloading is to use the Excel shortcut Ctrl+Alt+F9.

If you want to always recalculate automatically when reloading PyXLL you can use an @xl_on_reload callback to do that.

In your @xl_on_reload callback, you can use the Excel method "Application.CalculateFull", for example:

from pyxll import xl_on_reload, xl_app, schedule_call

# This function will be called when PyXLL reloads

@xl_on_reload

def on_reload(*args):

    # Schedule a full recalculate

    schedule_call(full_recalculate)

# This function is called via schedule_call once reloading has finished

def full_recalculate():

    # Get the Excel Application object and call Application.CalculateFull

    xl = xl_app()

    xl.CalculateFull()

In the example code above I have used PyXLL's "schedule_call" function to schedule the call to recalculate Excel. This ensures that reloading has finished before recalculating, as well as making sure that the xl_app function is being used safely (it should only be called from certain places, including macros and functions called using schedule_call).

Microsoft has a good page on how Excel recalculation works if you need more information about how recalculation works in Excel

https://learn.microsoft.com/en-us/office/client-developer/excel/excel-recalculation.

Related articles