Python calculations run in the Microsoft Cloud, with the results returned into an Excel worksheet. Excel users will be able to create formulas, PivotTables, and charts all based on Python data ...

Overall, the choice between VBA and Python for Excel automation depends on your specific needs. Even though it's outdated, VBA remains an integral part of Excel and is ideal for simpler tasks or ...

Users will be able to enter Python code directly into cells using the new =PY function, as Python will be integrated directly into the Excel grid, with no need to install additional software.

Python and Excel can only really talk to each other through limited functions—xl () and =PY ()—that can only return code results, not macros, VBA code, or other data, Microsoft claims.