A couple of years ago, Microsoft introduced Python support in Excel, supercharging the spreadsheet tool"s data manipulation capabilities even further. The company then added Copilot integration with the feature along with the ability to "read" pictures. Now, Microsoft has announced another enhancement that will be appreciated by customers leveraging this particular feature.
Although Microsoft hinted at this a bit earlier, the firm has now detailed the ability to configure an editable Python initalization script. While the Python editor in Excel predefines certain code on launch, Redmond understands that it may not cover all use-cases. As such, it is giving developers the option to configure an initialization script so that they can import the libraries of their choice or have boilerplate code ready at launch.
The new initialization editor enables developers to view and edit the initialization code to add library imports and functions, or reset it to the default state. You can leverage it simply by navigating to Formulas > Initialization. The initialization editor also offers some rich features such as syntax highlighting and line numbers. It also features error handling and prompts, such as one that warns you about potentially unexpected behavior the first time you apply changes to the script.
If you do have errors in your code, you"ll see affected cells showing the #PYTHON! value until you resolve all bugs in the script. Click the error icon next to the cell and click Show Error Message or Open Python Initialization to view additional details.
The editable initialization script is available for Insiders in Version 2509 (Build 19230.20002) or later, on Excel for Windows. You can give Microsoft suggestions about this feature and Excel in general through the Help > Feedback menu in Excel. And if you"d like to catch up on all that"s new in Excel, check out our dedicated coverage on the topic here.