Office Crashes when opening documents from SharePoint After Windows Update KB3055034

So Around October 13, 2015 Microsoft release an automatic security update that unfortunately started crashing Microsoft Word and other applications when you access files from SharePoint. Here’s the summary of the purpose of the update: “When a custom task pane is displayed in a document in Microsoft Word 2010, information isn’t updated in built-in task panes. For example, the formatting of selected text isn’t updated on the Reveal Formatting task pane.” –Microsoft Note other related updates with those issues may be KB3093983, KB3097966   How to Fix The...

read more

PowerPivot Gallery not loading, showing Install Microsoft Silverlight Message

The Issue Power Pivot in SharePoint used to load a gallery the workbooks and shows a screenshot of each report. However, sometimes you open the browser, navigate to the page and find that it’s not loading with a "Install Microsoft Silverlight" message. Even after installing Silverlight, it still says the same thing. Chances are you you are using Google Chrome. That is the crux of the issue. Google decided that Chrome will no long support many different types of plug ins, in an effort to conform with web standards, so they no longer support PowerPivot Gallery in SharePoint...

read more

Saving SharePoint login Credentials on iPad and iPhone

There is a common need for SharePoint users to access SharePoint sites using iPads and iPhones without having to constantly input their log in information each time. There is no native way in Apple Safari to cache user name and passwords for SharePoint. Any time a site is accessed the user is presented with a login screen like this one. Close your browser, or come back at a later time and Safari will ask again for that login and password. This post talks about some good and viable options to caching / storing your login info iPads and iPhones. Option 1: Using Atomic browser to cache...

read more

Scheduling Auto Refresh for PowerPivot Workbook

How to Setup A Refresh for your Workbook On the workbook that you wish to create a refresh schedule for, select the … that appear by the workbook –> Select the … that appears in the menu –> Select Manage PowerPivot Data Refresh Complete the form that appears below. Click the Enable Checkbox Set your desired refresh schedule. For the Credentials Field, "Connect using the credentials saved in Secure Store Service (SSS) to log on to the data source", enter the ID provided to you exactly as it appears. Under "Data Sources", Select the data sources...

read more

PivotChart Fields not showing in Power Pivot in SharePoint

Issue Details When a user clicks on a pivotable or pivotchart, the “PivotChart Fields” view automatically pops up. In other instances only Quick Explore pops...

read more

Whats up with SharePoint List message “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator”

This is covers a common issue many face when they have many items in their list. What you may experience: You try to view the contents of a SharePoint list and this message appears. The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator If you navigate to the list settings page you get: Solution 1: Changing the limit in Central Administration Note that if you’re on a shared hosting plan, then this option is not available for you. Navigate to Central Administration. You can get to it by going to the SharePoint server and...

read more