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:

1. Are running 32-bit version of Internet Explorer
2. Don't have a copy of Microsoft Office 2007 or 2010 available
3. 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: …

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:

<img
  loading="lazy"
  decoding="async" …</picture></figure></a></p>

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.

# script from netnerds.net # Make sure the namespace is the same as the namespace in your exported bdcm files # My $siteURL happens to be the same as my $namespace. …