Excel

For Office 365 customers this month, updates rolled out for Flow, PowerApps, Power BI, SharePoint, Teams, and even Excel.

If your Office 365 tenant has many private Teams, you might run the risk that people create duplicate teams because they don’t know that a team already exists. Teams doesn’t have a separate directory but you can create one with PowerShell and publish the output in Teams. The magic is provided by deep links, which users click to navigate to a team they want to join.

Another month has come and gone and the pace of change in the Office 365 ecosystem continues to wear me out.

If you use Office 365 and store documents in SharePoint or OneDrive for Business, the Office applications can autosave as you work to ensure that you never lose any content. It’s a good idea and the implementation works well. But I have a slight nagging doubt about the network impact for some tenants.

Microsoft Excel causes problems in genetic research. That’s the claim of three researchers from an Australian institute, who discovered almost 20% of data sets contained errors introduced by Excel. The problem is Excel being “clever”—guessing the type of data it’s being asked to import. Unfortunately…

Microsoft has announced the general availability of its REST API for Excel that will extend the capaiblites of the spreadsheet application to new products.

Microsoft’s productivity future is based heavily on the fact that corporations are addicted to Excel, and there is not a compelling alternative.

Jeff Hicks shows us how to easily query Excel workbooks as a database with some help from PowerShell.

Russell Smith serves us three helpful ways to connect to the Office 365 Reporting Service from Excel for easier report viewing.

In part three of this series, learn how to read data from an Excel file using PowerShell.