Share via

Python in Excel feature is Enabled. But can't insert formula writing =PY.

Anonymous
2023-08-24T07:15:45+00:00

I have enabled the "Python in Excel" module. but while writing in formula of any cell there is nothing named "PY" so can't code in cells.

Microsoft 365 Insider | Excel | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

29 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2025-06-07T17:20:08+00:00

    I have enabled the "Python in Excel" module. but while writing in formula of any cell there is nothing named "PY" so can't code in cells.

    Same here on Parallels Desktop running Win11 Pro 26100.2033 (MacBook Air, M4, 2025) and Microsoft Excel for Microsoft 365 MSO (Version 2505 Build 16.0.18827.20128) 64-bit from the Current Channel.

    Solved it by installing Python 3.13 package served through MS Store app and restarting Excel.

    Edit:
    "Same here" as in I "can't code in cells", it showed the following error message in a pop-up window: "The selected range contains a Python formula. You can update the Excel data in this workbook, like ranges and tables, but you won't be able to edit or create your own Python formulas."

    I did not see or install any "module" or an Add-In as one user in this thread prescribes as a possible solution through Options > Add-In menu.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-01-20T17:03:15+00:00

    My problem seems identical to yours. I followed the same steps. Are you saying that after waiting 5 days it magically appeared? Nothing else was needed?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-04-17T17:33:02+00:00

    I have the same problem. I am in the insider channel. I first installed the Anaconda Distribution of Python. The Python Icon does not show up and the Python in Excel Add-In does not show up in the COM AddIns. I installed a second Python distribution from the official Python Website. To no avail. Python In Excel does not work for me. Any suggestions?

    Was this answer helpful?

    0 comments