.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

Creating Solutions with Microsoft PowerPivot for Excel and SharePoint

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :SharePoint
 
Learn how to use PowerPivot to create, analyze, and share Excel 2010 workbooks in innovative ways by creating end-to-end solutions with PowerPivot for Excel and PowerPivot for SharePoint.


View Complete Post


More Related Resource Links

Creating Tracking Applications in Microsoft Office 2010 and Publishing Them to Microsoft SharePoint

  
Resources to help you develop manageable solutions for your organization to create, share, and collaborate on team databases; be more productive with Microsoft Access 2010 developer enhancements, and get started faster with one-click community templates.

Module 8: Creating Silverlight User Interfaces for SharePoint 2010 Solutions

  
SharePoint 2010 integrates closely with Microsoft Silverlight to enable you to build compelling user interfaces that interact with SharePoint data.

Learning Snack for Developers: Developing Solutions with Microsoft SharePoint 2010

  
Five videos on SharePoint 2010 development made easy, creating a SharePoint 2010 solution, deploying a solution, Silverlight applications and the client object model, LINQ to SharePoint, and more.

Microsoft Excel and Sharepoint KPI's (External Data Source)

  
This is my first post i hope i get a clear answer for my question. I recenty have been working on KPI's drawn from Microsoft Excel documents that i created. However, as we know, external data sources in excel don't work with sharepoint. If that was possible it would have saved the company a lot of time and effort My questions are: Is there any way to have external data sources with some advanced modifications, or any other way that would simulate this process? (External data update) Can i directly update my data by tampering the database where the excel file is saved?   I don't know if the files uploaded in sharepoint are stored in a database, so i want some validation around this. (Name of the database, path etc.)   Hope you can shed some light to my questions Thanks in advance Theo

Excel Web Part - different Powerpivot Slicer disabled tue to sharepoint users

  
Hello, first of all i'm new to sharepoint. I found quite similar question to mine http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/9f23a77c-1527-48a8-abbc-2ccded736d9e but unfortunately it hasn't been answered. So what i have done so far: I made a Excel 2010 Powerpivot chart and Published it to sharepoint via the Powerpivot gallery. I also created a Excel web part with the spreadsheed in it. I am searching for a vba script to achieve the sharepoint username but found only some for the windows username. I also managed to disable slicers in vba. What i want to achieve: Due to the fact that the Powerpivot chart has some critical security data in it the different users should only see two different filter options (whole data and one slice for themself) So i need to disable slicers in the pivot chart tue to the sharepoint accounts. My Qestion: Is it possible? If yes, how! Any help would be appreciated. Is it possible via VBA or do i have to use Excel web scervices?  Thanks for your help :)

Error Message PowerPivot Excel on SharePoint : "Excel was unable to get necessary information about

  

Hello everybody:

I get the error message “Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server” when I open the excel on the sharePoint site and the PowerPivot Datasource is already refreshed successfully on schedule.

I describe my steps more clearly.

  • Step1. Create Excel pivot tables and charts by using PowerPivot datasource which connects to SQL Server.
  • Step2. Publish Excel to SharePoint site. The Analysis Server will build a PowerPivot cube in "VertiPaq" StorageEngineMode automatically and the cube name including an "uniqueindentifier" in the end.
  • Step3. Schedule PowerPivot refresh plan on SharePoint and the successful result comes out soon. After PowerPivot refreshed the "uniqueindentifier" will be changed to another one automatically.
  • Step4. When I open excel on the SharePoint I will get the error message again. If I click the "ok" then Excel will really Refresh.

Now I have tried two ways:

  1. Locale setting: Doesn't work. It seems not to be the cause of my problem because it won't happen if my excel's datasource is connecting to DB or Cube directly.

    Creating and Publishing Excel 2010 Documents with Custom SharePoint 2010 Workflows

      
    Learn to generate Excel 2010 spreadsheets inside SharePoint workflows and publish them to SharePoint sites.

Creating an Excel Services and Bing Maps Mashup for SharePoint 2010 (Visual How To)

  
Learn how to use a Bing Maps AJAX control to interact with an Excel Web Access Web Part using the Excel ServicesECMAScript object model.

Video: Creating an Excel Services and Bing Maps Mash-up for SharePoint 2010 (Visual How To)

  
Watch a short video as you learn to use Bing Maps AJAX controls to interact with Excel Web Access web parts.

Exploring PowerPivot for Excel and SharePoint: Blue Yonder Charters

  
Explore a project that uses PowerPivot for Excel, Silverlight, and SharePoint Server 2010 to aggregate and share information, both inside and outside a firewall.

Sample: Creating and Publishing Excel 2010 Documents with Custom SharePoint 2010 Workflows

  
Explore the code as you learn to generate Excel spreadsheets inside SharePoint workflows and publish them to SharePoint sites.

Creating Discussion Board in Microsoft SharePoint 2013

  
Discussion Board is used for communication among team members. The discussion board shows the most recent discussion first on top, as well as the number of replies for each discussion. User can quickly see which discussions have the most recent activity and which ones are the most popular discussion. Members can also customize their own views of the discussion board

Creating your SharePoint Governance Plan

  
One of the most common questions that I get from prospects as I'm talking to them about the creation of a governance plan and process is what does it look like. In other words, there are materials available which describe what should be in a governance plan but there isn't a ton of guidance on what the process of creating a governance plan and process are.

Creating SharePoint items with CreateItemActivity

  
Instead of creating new list items from code in your workflow you can use CreateItemActivity. CreateItemActivity can be used for creating list items or files. Properties of interest for this activity are the following (most of them are self-explanatory):

Export SharePoint List to Excel Spreadsheet Programmatically using C#

  
In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Creating an Excel Spreadsheet programmatically using VB.NET

  
The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000. The majority of Excel programmatic functionality is exposed through Automation via the type library Excel9.olb. The intention of this article is to express that a managed application can interrelate with Excel as a COM server.

Creating an Excel Spreadsheet and Adding Data to It Programmatically

  
The Interoperability services make it veryeasy to work with COM Capable Applications such as Word and Excel. Thisarticle reveals using Excel from a managed application. Excel is thespreadsheet component of Microsoft Office 2000. The majority of Excelprogrammatic functionality is exposed through Automation via the typelibrary Excel9.olb. The intention of this article is to express that amanaged application can interrelate with Excel as a COM server.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend