Posts

[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
SharePoint 2010: Stop Mixed Content Prompts on RSS Feeds Viewed on SSL-enabled Sites
Jan 30, 2012 · 2 min read ·
Share on:
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 …
Read More
- 17
- 18
- 19
- 20
- 21