Issues that are fixed in this update. The following issues are fixed for .NET Framework 4.7.2. SQL Server (SQL) Fixes an issue in which the .NET Framework API SqlConnection.ConnectionString property is used to set a null or empty connection string. In this situation, a Null Reference Exception (NRE) occurs when you use the API together with .NET Framework 4.7.2.

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.

A basic profile consists of one or more email accounts and a storage file. A private individual might have an Internet email account, such as a POP3 account, while corporate workers might have a Microsoft Exchange account. Accounts of other types (including IMAP4 and HTTP accounts) can be added to any profile, and so can additional storage files (such as an Archive.pst file for keeping older ...

Choose Open all, or Open all in new window, or Open all in new InPrivate window.

Right-click the app, select More, and then select Open file location.This opens the location where the shortcut to the app is saved. If there isn't an option for Open file location, it means the app can't run at startup.

When you enter some text into a cell such as "2/2", Excel assumes that this is a date and formats it according to the default date setting in Control Panel.Excel might format it as "2-Feb".If you change your date setting in Control Panel, the default date format in Excel will change accordingly.

On the Choose an account screen, click the Microsoft account button.; On the Add your Microsoft account screen, enter the email address and password associated with your Microsoft account.; On the Make it yours screen, you'll have the option to make this Microsoft account your primary account. (This makes sign-in, settings, and syncing happen automatically for all other Microsoft services.)

After you set up your security verification methods for your work or school account, you can update the related details. Using the Security info page

If you try to add an IMAP account to Outlook, for example a Gmail account, Apple account, Yahoo account, or an account from your local ISP, and you're not prompted to enter your password, use the following steps to work around the problem.

Insert or delete rows, and columns Article; Select cell contents in Excel Article; Freeze panes to lock rows and columns Article; Hide or show rows or columns