Excel for the Internet receives a function that you have expected for life

It is no secret that many users consider the web application of Office as a “lower” version. This is the case Emergwhich reserves the most powerful characteristics for calculations and operations for a desktop application. Microsoft wants to reduce the gap, and today announced that A very popular power function will enter Excel for the InternetField

In the message on the blog Technical communityMicrosoft said that Excel for the Internet can already update authenticated data sources directly using Power Request. This means that users no longer need to upload a file and do it in a desktop application to synchronize it. Now it is possible automatically update consultations connected to data sources that require authentication Right from the browser

This function, available to all Excel users for the Internet, is compatible with data sources, such as SharePoint, OneDrive, SQL Server, Web API, PostgreSQL, SalesForceAnd others that require the user and password. Function Performed in the background Thus, users can edit the book while the data is updated.

Updating consultations with support for authenticated sources up to 1000 user connectionsWhen executing an update through the request panel, users can sign a signature with their user name and password through an organization account or anonymously. New function Allows you to store and manage accounting data directly in the book Use them in the future.

As expected, update Excel For Web also offers integration with AIThe field users can turn on the function Import with Co -pilot which is based on a power request for automatic data updating.

Microsoft promises an electricity editor in Excel for the Internet

Yes, good Power request is one of the most important components ExcelHis presence was denied the Internet. Today’s update price, users had to upload a file, open it in Excel for the desktop and update the consultations, entering the accounting data. The Internet showed only the results, but did not allow editing the logic of consultations.

The new function will allow you to connect several sources of data or automate repeating tasks from the browser. Although there are some characteristics, Microsoft promised that Offer the full experience of the Power Query editor in Excel for the InternetAfter implementation, users can create expanded transformations, combine and combine sources, create personalized logic and much more.

At the moment, there are no details about this integration, although by the time when it was required to implement today’s update (3 years), do not expect the editor of Power Query Sleess for Excel on the Internet.