IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. Overview Here's a scenario: imagine that you are a SharePoint Online administrator and you have been asked to provide analytics about how the … Continue reading Four Options for SharePoint Site Analytics
Category: Excel
Loading CSV/text files with more than a million rows into Excel
1. The Problem If you usually load a very large CSV (comma-separated values) file or text file into Excel, you might run into the dreaded "File not loaded completely" message: As the message explains, the file you are trying to load is too large for Excel to handle. For me, it typically happens with large … Continue reading Loading CSV/text files with more than a million rows into Excel
Jose Barreto's Blog 