There is, however, one big exception to this rule. You probably won't encounter such problems very frequently as long as you don't work with obscure file formats that aren't supported by Excel. When the particular file format you're using isn't supported by Excel, importing data may be slightly more complicated.Īs a general matter, I have no problems with these limitations. However, the Get External Data group of commands isn't the topic of this blog post. In some of these cases, the tools you require to do the job are readily available in Excel's Get External Data group of commands within the Data tab. The most common text file formats, such as comma-separated values (.csv) and text (.txt) files.Switching functionality on/off is done by licensing manager assuming such functionality code is within your current build.Most recent versions of Microsoft Office have several features that allow you to, among others, import data into Excel from the following sources: For such changes it's not necessary to update the build, it's enough if you connected to internet. But that happens quite seldom and not on semi-annual channel. If you'd like to have new functionality faster you need to change the channel.Īnd yes, Microsoft could deploy some new functionality and in a while cancel it due to some critical bugs. In general deployment of new functionality to all Office365 subscribers, from first Beta users to slowest semi-annual channel users could take couple of years.

Thus you have to compare SKU, channel and it's version to compare functionality, plus some time for the deployment. And more exactly on version within such channel (semi-annual has 3 versions). Within SKU availability depends on the channel you are subscribed. You may check availability by SKU here Where is Get & Transform (Power Query) - Excel ()

You shall do business using business subscription. The difference with business/enterprise subscriptions is mainly in licensing - in brief you are not allowed to earn money with Home subscription.

Insert pdf in excel 365