Category: SharePoint

SharePoint 2010: Creating Dashboards and Charts for SharePoint Lists using PerformancePoint and Excel Services from Start to Finish

I really thought making SharePoint Lists into pretty graphs and charts in SharePoint would be far more straightforward than it’s turned out to be. Recently, I was given a project where I had to do just that and while I

Posted in BI, SharePoint

[Solved] Annoying Scrollbars in Excel Web Access Web Parts and PerformancePoint w/ Excel Services

Recently, while using Excel Services to access PivotCharts and PivotTables within Excel Web Viewer Web Parts and PerformancePart Dashboards, I encountered vertical and horizontal scrollbars that would not go away, no matter how much I tried resizing. god don’t like

Posted in BI, SharePoint

[SOLVED] PowerPivot for SharePoint 2010: An error occurred connecting to this data source.

I’m currently working on a project where I need to quickly make pretty graphs and charts for data in small but important SharePoint lists. After looking through a number of books and consulting with my SharePoint buddies, PowerPivot for SharePoint

Posted in BI, SharePoint, SQL Server

[Solved] SharePoint 2010: Obtaining STSUPLD.DLL without installing Microsoft Office

If you find that “Upload Multiple Files…” is greyed out or otherwise unavailable in SharePoint 2010 and you: Are running 32-bit version of Internet Explorer Don’t have a copy of Microsoft Office 2007 or 2010 available Have added your SharePoint

Posted in SharePoint

Map a Secure SharePoint 2010/IIS Network Drive over SSL and WebDAV in Windows 7

Once, after viewing a SharePoint 2010 document library in Windows Explorer, I ran a net use and saw that Windows 7 had stored the credentials of my SSL-secured SharePoint intranet server. It took a bit of fiddling, but I eventually

Posted in IIS, Security, SharePoint

SharePoint 2010: Stop Mixed Content Prompts on RSS Feeds Viewed on SSL-enabled Sites

I started on a new client site last week and my first task was immediately clear: I had to remove the Mixed Content Security prompt on the encrypted SharePoint intranet’s front page. Firebug showed that my browser was making calls

Posted in Security, SharePoint

SharePoint: Simple Sample Approach to Autonumber

Below is a formula for a quick and dirty autonumber for lists in SharePoint. There are a variety of ways to generate this field. Some solutions use workflow or external lists, but I prefer this method because of its simplicity.

Posted in SharePoint

SharePoint 2010: Use CSS to Auto-expand Calendar Entries

I looked all around the web for a simple solution to auto-expanding events in a monthly Calendar view. Unfortunately, this isn’t something that’s built-in to SharePoint, so it has to be done using workarounds. There were many solutions suggested on

Posted in SharePoint