Tag Archives: Best of 2018

These posts are the most popular of those published in 2018 on SharePoint Librarian.

Solution: “We’re sorry. We can’t open {file} because we found a problem with its contents.”

When using SharePoint Designer workflows to automatically create documents from a template you might run into an error message: “We’re sorry. We can’t open {file} because we found a problem with its contents.” Or if you’re just opening it within the browser web app instead of the Word client, you might have seen: “Sorry, Word […]

How to resolve SharePoint list view threshold error: “The view cannot be displayed because it exceeds the list view threshold…”

SharePoint lists have a default limit of 5,000 items per view. But lists can contain 30 million items (just not all available in one view). Since you’re reading this, perhaps you’ve already learned this from an error message such as: The view cannot be displayed because it exceeds the list view threshold (5000 items) enforced […]

How to create a SharePoint Governance Plan (includes template)

What is governance? The Burton Group says “Governance uses people, process, technology, and policies to define a service, resolve ambiguity, and mitigate conflicts within an organization.” I would only add that it specifically helps create a consistent user experience which, in turn, promotes better adoption. I like the Burton Group’s definition because it doesn’t rely […]

Using today’s date and/or current time in calculated columns and list view filters

I previously shared how to create a “Today” column in SharePoint that would always be up-to-date even if list items weren’t modified. These were no-code solutions that utilized either SharePoint Designer or Microsoft Flow. You can, however, use Today’s date/time to create views and calculated columns without workflow or script or the need to create […]

How to create a powerful date table or DateKey in Power BI

DateKeys are essential for relative time measures. In “manage relationships” you tie the ‘DateKey'[Date] to a date field in each of your data sources. Giles Walker shared an excellent solution for a robust DateKey that includes measurements and calculations you’re sure to find useful. Here’s that same solution I’ve modified and expanded to be as […]