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. To accomplish the above, you have to do two things. In Dashboard …

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 2010 seems to be the best tool for the job. Getting it to work hasn't …

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 site to the Trusted or Intranet Security zone in IE You can …

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 found you can, in fact, map a secure network drive using the command line: net use W: …

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 to feeds.feedburner.com even though the RSS feed was an entirely different address at …

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. Note: Because this solution depends on the record's ID column, it generates the autonumber …

The free tool SharePoint Manager 2010 is super useful. Imagine a centralized place to look at everything on the server level from Content Type usage to running jobs and IIS setting. Check it: I found it after looking for a non-PowerShell solution to solve the whole "Content Type in Use" issue. The only …

Here is a script that will batch import Models, create associated ECT's, and set permissions for users and admins. Please modify the variables as needed. The script does the following: Scans current directory for BDC Export (.bdcm) files Creates the External System/Lob and the External Content Types Creates External …

In order to invest as little effort as possible creating and recreating and recreating my External Content Types on my development server, I exported the ECT's then deleted External Content Types, External Systems, and BDC Models. I saved them all in a directory on the SharePoint server, then I placed …

Today has been miserable. All I wanted to do was import a SharePoint 2007 calendar into SharePoint 2010 to use as sample data for a prototype site. I was caaarraaazzy enough to believe it would be a simple import/export, but no. There's no such thing. Maybe I could use Outlook calendaring or idq files as a medium? No. …