Python in Excel DataFrames - Microsoft Support
Python in Excel can output a DataFrame in two ways: as a Python object or converted to Excel values. When a DataFrame is returned as a Python object, the cell displays the text "DataFrame", preceded by a card icon. The following screenshot shows a DataFrame as a Python object in an Excel cell.
Applies To:
Excel for Microsoft 365
Use Power Query to import data for Python in Excel
To work with external data with Python in Excel, enable Python in a cell by entering the =PY function. Next, use the Python in Excel xl () formula to reference Excel elements, like a Power Query query. For this example, enter xl ("Categories") into the Python in Excel cell.
Applies To:
Excel for Microsoft 365
KB4134601 - FIX: "Could not load file or assembly 'Microsoft ...
Fixes a problem in which you receive a “Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClientUI” error message when a Process Full operation is run in SQL Server.
FIX: Error occurs when Microsoft.BizTalk.Analytics.Common assembly is ...
Could not load file or assembly 'Microsoft.BizTalk.Analytics.Common, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
Data security and Python in Excel - Microsoft Support
Python in Excel is General Data Protection Regulation (GDPR) and European Union Data Boundary (EUDB) compliant. Python in Excel runs in the Microsoft Cloud with the following attributes. Python code runs within the compliance boundary of your organization on hypervisor isolated containers.
Applies To:
Excel for Microsoft 365, Office for business, Microsoft Office
Dynamic array formulas and spilled array behavior
Formulas that can return arrays of variable size are called dynamic array formulas. Formulas that are currently returning arrays that are successfully spilling can be referred to as spilled array formulas.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Office for business, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Microsoft Office
Rules for changing array formulas - Microsoft Support
To change or edit an array formula, you need to follow some rules, especially if you have multi-cell formulas. This article spells out the rules.
Applies To:
Excel 2013
How to correct a #VALUE! error in the SUMPRODUCT function
Problem: The array arguments don't have the same dimension. All of the array arguments should be the same dimension. If they're not, then you get the #VALUE! error. For example, if Array 1 refers to a range of 3 rows and 2 columns, then Array 2 must also correspond to the similar range. =SUMPRODUCT(D2:D13,E2:E10)
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
November 21, 2017—KB4055038 - Microsoft Support
Describes update 4055038, including known issues and how to get the update.
KB4468101 - Improvement: Optional replacement for "String or binary ...
When you try to store string or binary data that exceeds the target column size in Microsoft SQL Server, you receive the following error message: Msg 8152, Level 16, State 6, Procedure ProcedureName , Line Linenumber