'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Use Python in Excel with Personal and Work Accounts
Question details
The user needs to access Python in Excel on both home and work computers while maintaining separate personal and work Microsoft accounts.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to use premium features like Python in Excel across multiple devices using different Microsoft account types.
- Observed behavior
- Premium Python in Excel features are tied to the specifically licensed account and do not automatically transfer between personal and work accounts.
Verify which of your Microsoft accounts (personal or work) currently holds the active Microsoft 365 subscription with the Python in Excel add-on license.
Sign in with the Licensed Personal Account on Your Work Device
To use your personal Python in Excel subscription on a different computer, you must sign in to Office using your licensed personal account.
Microsoft Office licensing is tied to the account, not the software installation. If you purchased the Python in Excel add-on on your personal account, those premium benefits will not automatically apply to your work account, even on the same device.
Launch Microsoft Excel on your work computer. Click on 'File' in the top left corner, then select 'Account' from the bottom left menu.
Under the 'User Information' section, click on 'Switch Account' or 'Sign In'.
Type in the email address and password for the personal Microsoft account that contains your Python in Excel subscription.
Close and reopen Excel to apply the license changes. Check the Formulas tab or type '=PY(' in a cell to verify that Python features are now active.
Acquire a Separate Python in Excel License for Your Work Account
If employer policies prevent you from using personal accounts on work devices, you will need a separate Python in Excel add-on assigned directly to your work account.
Try WPS Office for Powerful Spreadsheet Management
If managing multiple Microsoft 365 subscriptions and premium add-on licenses across devices becomes too costly or complex, consider switching to WPS Office. It provides a highly compatible, lightweight spreadsheet solution completely free of charge.
- 1. Download the Software: Visit the official WPS Office website and click the 'Free Download' button.
- 2. Install WPS Office: Run the downloaded installer and follow the quick setup wizard to install the suite on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and directly open your existing Excel workbooks to continue your data analysis without formatting loss.
Frequently Asked Questions
Why is the Python in Excel feature missing on my work computer?
Python in Excel is a premium feature tied to specific Microsoft 365 subscriptions. If you are signed in with a work account that hasn't been assigned the required Python add-on license by your IT administrator, the feature will not appear.
Can I merge my personal and work Microsoft accounts to share the Python license?
No, Microsoft does not allow merging personal and work accounts. You must actively switch between the accounts within the Excel 'Account' settings to access the licenses and features tied to each specific account.
Is the Python in Excel add-on free?
While a limited preview version may be available to certain Microsoft 365 Insiders, full access to the premium cloud compute resources required for Python in Excel requires a specific paid add-on license.
