Posts

SharePoint 2010 Task List Validation: Comparing Two Columns, Status and % Complete
Apr 12, 2012 · 1 min read ·
Share on:
Did you know that SharePoint supports list validation in addition to column validation? I've seen the option 100 times before but it never clicked before I actually needed to use it. In this case, I needed to make sure that anyone setting a task item Status column to Completed" was also filling setting the % …
Read More
[Client-side Workaround] SharePoint 2010 Excel Services cannot Automatically Refresh Data when using SharePoint Lists as a Data Source
Apr 6, 2012 · 4 min read ·
Share on:
So far as I can tell, Excel Services is not capable of automatic data refreshes when using SharePoint Lists as a data source. If you're looking for this functionality, you have two choices: PowerPivot (best) or scheduled client-side data refreshing (ghetto).
In order for Excel Services to communicate with other data …

Read More
SQL Server 2012 PowerPivot Services: Service Account Keeps Getting Locked Out
Mar 29, 2012 · 1 min read ·
Share on:
Okay, I've had to call Helpdesk an embarrassing 8 times today because my PowerPivot upgrade is going horribly wrong and locking out my AD account that, admittedly, I use as a "service" account. I'm really left with no choice -- I'm only granted one account on this network. Restrictive networks are so …
Read More
When xp_delete_file doesn't work as expected...
Mar 29, 2012 · Brandon Abshire · 2 min read ·
Share on:
Whether you use a Maintenance Cleanup Task as part of a SQL 2005 or 2008 Maintenance Plan, or script out your own cleanup t-SQL, you are probably using the xp_delete_file extended procedure. For quite a while, I've occasionally come across old TLog or backup files that were missed. Without questioning it, I would clean …
Read More
SharePoint 2010: Creating Dashboards and Charts for SharePoint Lists using PerformancePoint and Excel Services from Start to Finish
Mar 14, 2012 · 6 min read ·
Share on:
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 read through about 30 SharePoint BI books, none really gave a straight answer on which of the various …
Read More
[Solved] Annoying Scrollbars in Excel Web Access Web Parts and PerformancePoint w/ Excel Services
Mar 13, 2012 · 1 min read ·
Share on:
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. …
Read More
[SOLVED] PowerPivot for SharePoint 2010: An error occurred connecting to this data source.
Mar 7, 2012 · 4 min read ·
Share on:
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 …

Read More
Patterns and Practices: A Guide to Claims-Based Identity and Access Control - Free ebook.
Feb 24, 2012 · 1 min read ·
Share on:
While I usually like conversation-style technical books (think: Manning's In Action series and many Wrox books), Microsoft's Patterns and Practices series is one of my favorite even though they feel so formal. Recently, my buddy Buck Woody posted a link to the freely available Patterns and Practices book for A Guide to …
Read More
[Solved] SharePoint 2010: Obtaining STSUPLD.DLL without installing Microsoft Office
Feb 21, 2012 · 1 min read ·
Share on:
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 …

Read More
Map a Secure SharePoint 2010/IIS Network Drive over SSL and WebDAV in Windows 7
Feb 6, 2012 · 1 min read ·
Share on:
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: …

Read More
- 17
- 18
- 19
- 20
- 21