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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010

View Complete Post

More Related Resource Links

Integrating External Data and Microsoft SharePoint 2010 Platform Services in Microsoft Office 2010 S

Microsoft Office 2010 integrates with SharePoint more closely than in previous versions. The resources here show you how to take advantage of the powerful collaboration infrastructure.

SharePoint 2007 & Office 2010: not accepting data in required fields


We recently upgraded everyone to Office 2010, but we are still using MOSS 2007. Since the Office upgrade, I am getting numerous reports of problems with the 'required fields' of any document be editing (or newly created) when users try to save it back to the server.

These documents are throwing error messages indicating that some required properties 'are missing or invalid'. However all the needed info is indeed there. Even existing documents (that already have the field data in place) are giving the message when a save (or save as) is attempted. However, if the user saves a copy of the document locally and then manually uploads it via the SharePoint UI, it works fine. It appears to only come up when they use an Office app for editing and try to save it directly back to the server from the app. This process worked fine with Office 2007.

This only started when the Office 2010 upgrades were rolled out, and (as far as I know) no changes were made to SP at all. I have never seen this phenomenon before, so I would greatly appreciate any advice and/or education on this.  :)


Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Office Services: Merging Word Documents on the Server Side with SharePoint 2010


Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010

In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


Quick Note: Accessing Data in a SharePoint 2010 Web Part by using LINQ

In this exercise, you develop and deploy a visual Web Part that reads data from two lists by using a LINQ query and displays it in a DataGrid control.

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.

Video: Office Client Workflow: Visual Studio 2010 SharePoint Workflow

Learn how project templates for SharePoint 2010 in Visual Studio 2010 allow developers to build sequential and state machine workflows for SharePoint and import reusable workflows created in SharePoint Designer. (Length: 10:36)

Video: Accessing SharePoint 2010 List Data

In this video you will learn how to create strongly typed classes using a tool called SPMetal to do LINQ programming against a SharePoint 2010 list. (Length: 15:22)

Module 5: Accessing SharePoint 2010 Data with Client-Side APIs

SharePoint 2010 provides a new client object model that enables you to create SharePoint solutions that run remotely from the SharePoint server farm.

Module 6: Accessing External Data with Business Connectivity Services in SharePoint 2010

SharePoint 2010 provides a new set of technologies known as Business Connectivity Services for retrieving, editing, updating, and deleting data from external systems.

Video: Accessing SharePoint 2010 Data on the Server

This video provides an overview of approaches for accessing SharePoint 2010 data by using the server-side APIs. (Length: 3:32)

Video: Accessing SharePoint 2010 Data from a .NET Application

This demonstration shows how to use the client object model from a Windows Presentation Foundation application. (Length: 5:26)

Video: Accessing SharePoint 2010 Data in Silverlight by Using CAML

This demonstration shows how to use the client object model and CAML to access SharePoint data in Silverlight applications. (Length: 6:39)

Office 2010 will not open Office 2003 Documents on SharePoint

Going directly to a document in the document view and selecting any of them will present the Read Only/Edit prompt and when clicking Read Only Word or Excel 2010 depending on the document type will open to a blank page and just sit there. If you do a search and then click on the documents that are returned in the search results, it opens as expected.

Microsoft Office Picture manager is not launched in sharepoint 2010 picture library

Hi ? I am stuck up with :? Microsoft Office Picture manager is not launched in sharepoint 2010 picture library The description is : ? All the photos are stored in a picture library in the root of the My Sites called User Photos.? They are then stored in a folder called Profile Pictures. Navigate to your profile home page, delete default.aspx and type in ‘/user photos/’? (for example   ? But When I tried the edit option : Open Picture in a Picture Editor The page is blank : Microsoft Office Picture manager is not launched. ? Kindly help , if any service or step is missing. http://sp2010/my/user photos/).? This will take you to the root and then navigate to the folder Profile Pictures.http://sp2010/my/user photos/)

Accessing SharePoint Workspace through Windows Explorer and Office applications

In windows explorer, there is a folder named workspaces. But it is blank and doesnt show any workspaces. I am using office 2010 pro in Win 7 64 bit. As per this article http://blogs.msdn.com/b/sharepoint_workspace_development_team/archive/2010/06/08/surfacing-sharepoint-workspace-data-through-windows-explorer-and-office-applications.aspx, it should be possible.Amila Hendahewa | www.docudude.com/ | @docudude |
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