Updated 28-Oct-2010: Some folks are reporting that an iisreset is needed to make the updates visible to SharePoint.
So . . . here I am playing around with PowerPivot to get ready for a demo. As this is a group from the SharePoint dev team (actually SharePoint Online), I wanted to include some cool SharePoint functionality [...]
So I am playing around with the PowerPivot add-in constructing a new sample application. I’ve got the data and I am inserting pivot tables in my worksheets. All of a sudden I noticed that the field list isn’t the PowerPivot field list – it is the Excel field list. What happened? (I never did figure [...]
1 — Is this a single machine farm? Will it be used for departmental use? Then go for “New Server”: http://msdn.microsoft.com/en-us/library/ee210708.aspx This is NOT a standalone machine in SharePoint terms (PowerPivot does not support standalone SharePoint installations) — It is a full farm with all the capabilities of a farm, it is just that we [...]
Make sure you buy *big* disks for your system drive!
I just ran into an interesting thread from one of the SharePoint support forums. As I am sure that you are aware of (sic) SharePoint has a new high severity health rule for SharePoint 2010 that raises an error if your machines does not have 2X [...]
I having been playing around with a new SharePoint 2010 feature called the Developer Dashboard. It is a great tool to use when figuring out how your pages work behind the scenes.
See some previous postings on the topic here: http://blogs.technet.com/b/speschka/archive/2009/10/28/using-the-developer-dashboard-in-sharepoint-2010.aspx http://powerpivotgeek.com/2010/05/18/enabling-the-sharepoint-developer-dashboard/
To disable the Developer Dashboard:
STSADM.exe –o setproperty –pn [...]
It has been a while since I did one of the “A Peek Inside” postings and I thought “what the heck . . . do I have anything better to do while I am visiting with my in-laws during a vacation” . . . I couldn’t think of one so here goes.
PowerPivot has some special [...]
Is now available here: http://msdn.microsoft.com/en-us/library/ff976569.aspx
From time to time I get questions from folks asking me “What is the best debugging tool for PowerPivot?” – The Answer is that there is clear cut favorite and it is EXTREMELY useful, but I didn’t know that it was released to the public. Well . . . after some investigation, it looks like [...]
Microsoft does not recommend or support the use of Office applications in a server-side environment (see http://support.microsoft.com/kb/257757 ). In the case of PowerPivot, the data refresh facility is implemented within an NT Service and, as such, falls under this restriction. In this article we will use the ACE provider to give you more control [...]
(my thanks to Dan English http://denglishbi.spaces.live.com/ for the solution in this post)
Dan’s system failed trying to bring up the Workbook Activity or Server Health workbooks as part of the PowerPivot Management Dashboard in Central Admin. The error was: “The file that you selected could not be found. Check the spelling of the file name and [...]