.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

SharePoint like functionality for Office Documents

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint

We have a document library that is built inhouse. We are migrating to SharePoint 2010, but this will be a long process and many very old documents may not get moved to SharePoint. I would like to provide the same experience for our users when they open a document from SharePoint or our legacy system. The behavior I would like is that of the SharePoint Server Workbook and Server Document.

I am not sure what this technology is called or where to start looking to configure this or integrate into an addin.

Any starting points are much appreciated.



View Complete Post

More Related Resource Links

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

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.

How to save Office 2007 documents to SharePoint 2010 sites

Is it possible to save Office Word/Excel/Powerpoint 2007 to SharePoint sites directly from Office Clients? Following website helps with saving a Office 2010 document to SharePoint 2010, but how to do it with Office 2007? http://office.microsoft.com/en-gb/word-help/save-a-document-to-sharepoint-from-office-2010-HA010380214.aspx  Kenny_I

Publish Office 2007 documents with metadata to SharePoint 2010?

Hi. I have SharePoint 2010 Enterprise based Intranet solution. We are publishing office 2007 documents to various document libraries there. When uploading documents normally to the document library, I can enter managed metadata to the documents which are later sorted and filtered by this metadata. But how can I enter metadata at the point where I'm publishing the document(Publish->Document Management Server)? I can get the document management pane to show my metadata -column in word as a textbox after the document is published, but the textbox is colored grey and says that I should modify that data on the server i.e. from sharepoint.

Can't open SharePoint documents in Office 2010

Hi, I have a SharePoint 2010 standalone installation and a SP 2007 with SQL back-end installation for testing and proof of concept demonstrations.  All the servers are running Windows 2008 Server and are on a vSphere 4.0 ESX server as virtual machines. Most of the pilot team are on Office 2007 and are working fine with the installations.  I am running Office 2010 (not beta) and am unable to open any Word or Powerpoint files in a standard Project site's Shared Documents library. (I can open a word document stored and linked from a publishing site.) Whether I browse to the file or click the link in a search results page, Powerpoint and Word load up but before I get any login prompt or application screen appearing, the application crashes.  This occurs whether I open the document Read only or click the implicit check out 'Edit' button. If I check the document out to my local drafts folder I can open normally.  As I can't find anything about this on the internet I'm guessing it's not a common occurence!

Sharepoint 2010, Constant prompt for credentials to edit office documents in a fqdn setup


Is there a solution to resolve the constant "Prompts" For user id's and passwords when a person tries to open/launch/edit office documents from sharepoint 2010.

My setup: sharepoint fqdn in the domain sp.domainname.local, The sharepoint server is a member of this internal domain. In dns I have local zone of sp.domainname.com with a cname that points to the internal sharepoint server. There is no issue in users accessing the server both internal and external, The issue arises when Office documents are launched from SP2010.

In central admin I have configured the alternate access mappings to be http://sp

I have also tried putting the fqdn dns name of the sharepoint server in IE8 trusted zone but
no luck, I still get credential prompts.

I think the issue might be that Office does not see that the files are coming from the fqdn of sp.domainname.com so hence the prompts.

Trying to fix this as right now its a total pita. I found some previous posts on this issue with SP2007 but found nothing that really addresses this in SP2010.

Thanks Paul

SharePoint ItemUpdating EventReceiver and Office 2007 documents -- columns not updated



We've created an ItemUpdating EventReceiver that sets various properties (columns in the library) on the document based on user selections in a couple other properties.  This code works fine and for all file formats in a Windows 2003 Server/MOSS 2007 environment.

In a Windows 2008/MOSS 2007 environment, however, when we upload MS Office 2007 documents (e.g. docx, xlsx, pptx) these updates are not made.  What's interesting is that the code does actually execute (we've compared logging statements for non-MS Office 2007 files to MS Office 2007 files, and all settings being equal, the code executes exactly the same way on both files, but when the library list view is refreshed, the pre-MS Office 2007 document HAS the values, but the MS Office 2007 documents do not!.

Anyone have any idea why this code is not able to "commit" the values to the documents?  Again, the code works fine (per our logging output), it's just that the values do "not take".....Is there something in the Windows 2008/MOSS 2007/Office 2007 "integration" that might be interferring or that would prevent values form being updated?

Login prompt when opening office documents in SharePoint 2010 library


Environemnt : SharePoint 2010
Windows based authentication being used for site. All SharePoint servers part of the same network.

When i try opening office documents from document library( .docx, xlsx), SharePoint prompts for login credentials even though i am already logged into the website, worse part is that it prompts me for credentials for every document that i open. Also any files other then PDF opens up in the local machine's office application (word or excel) instead of in the browser.

I had migrated this webspplicatoin from MOSS and then did a visual upgrade as well to it, when i verified in the MOSS version of the site after i am log into the site ones it never prompts for login credentails ever when opening an office document.

Any body knows why this is happening.


Long delay opening Word documents from SharePoint 2007 with Office 2010


The first time a document is opened it's fine, opens in just a few seconds.

Subsequently, there is a long delay (about 20 seconds) in the "Contacting server for information..." step.

This happens to all users and all documents, each one will open fast the first time then slowly the second and subsequent times (until, we think, the app pool is recycled - there is no schedules iisreset/reboot).

This does not happen when using Office 2007.

IE6 and 7 exhibit the same behaviour.

Can I save documents to a website like from Office apps to SharePoint?


We're developing an Office add-in that will store documents in a database. What I'd like to be able to do is save the document to the server using a web-style address (e.g. http://documentsystem/NewDocument.docx), kind of like how it's done in SharePoint. The user does not need to enter the full address, it will be configured elsewhere, and the save process will be more or less automated.

When uploaded, I want to intercept the file, read the contents and store it in the database using some kind of custom handler. Is this possible? How would I go about doing this? Should I be using WebDAV? WCF services?


All documents open as Read Only in Office 2010 from SharePoint 2007


I have recently installed Office 2010 and now when I select "Edit in Microsoft Word" from a SharePoint document library, the document will only open as Read Only.  I am running SharePoint 2007 SP1, I have admin rights to the workstation, server, sharepoint list and document.

I have tried the registry entry " OpenDocumentsReadWriteWhileBrowsing = 1 " but that has made no difference.  I have also run webfldrs.msi with no effect.  The website is a trusted site and I have switched off all of the protected view options.

Any help welcome!

How to prevent Sharepoint 2007 from adding Custom XML to Office 2007 documents


When I upload an Office 2007 document to Sharepoint, its metadata is modified. Here is what I found:

Original file:


filename - docProps/app.xml

filename - docProps/core.xml

filename - xl/worksheets/sheet1.xml

filename - xl/styles.xml

filename - xl/sharedStrings.xml

filename - xl/worksheets/sheet3.xml

filename - xl/worksheets/sheet2.xml

filename - xl/theme/theme1.xml

filename - xl/workbook.xml

filename - xl/_rels/workbook.xml.rels

filename - _rels/.rels

filename - [Content_Types].xml

mimetype - application/zip


File in Sharepoint:



filename - customXml/_rels/item3.xml.rels

filename - docProps/custom.xml

filename - customXml/itemProps3.xml

filename - customXml/item3.xml

filename - customXml/_rels/item2.xml.rels

filename - customXml/itemProps1.xml

filename - customXml/item2.xml

filename - customXml/itemProps2.xml

filename - customXml/_rels/item1.xml.rels

filename - customXml/item1.xml

filename - docProps/app.xml

filename - docProps/core.xml

filename - xl/worksheets/sheet1.xml

filename - xl/styles.xml

filename - xl/sharedStrings.xml

filename - xl/worksheets/sheet3.xml

filename - xl/worksheets/sheet2.xml

filename - xl/theme/theme1.xml

filename - xl/workbook.

Sharepoint Foundation 2010 - How to search non MS office documents


I came across the following article


The article states the following

"I discovered that SharePoint Foundation does not allow iFilters. Therefore, pdfs cannot be scanned and cannot be included in Search. This is going to be a major bummer for some people.
Fortunately, solutions involving SharePoint Server 2010 and SharePoint Search do exist. As you may know, both these products are not free, and there are some constraints about where and how Search can be installed.
After quite a bit of research on the “Search” dilemma, I’ve been successful in discovering the solution to the problem for SharePoint Foundation 2010 clients. It cannot be found in the SharePoint 2010 manual and it was by no means easy."

The solution is NOT provided so I don't even know if this is even real...

Anyway my question is, does anybody knows a way to Search non office documents with Sharepoint Foundation 2010 (like pdf's, jpeg, etc.)?

Thank you!

Unable to save Office 2007 document to SharePoint My Site Personal Documents document library


...also when Office documents are saved to document library they open as Read-only and cannot be saved back to the same document library.

This only happens in my production SharePoint 2007 environment from client XP and IE7 machine.  It does not happen in developement environment (which mirrors production) from client XP/IE7 machines.

Save works fine to SharePoint document libraries from client Win 7 and IE8 machines in both production and development environments.

This only happens when attempting to save to a My Site Personal Documents document library.  Any other document library this behavior does not exist from XP or Win 7 machine.

What settings controls ones ability to save to a personal My site document library.  What setting could be different between prod and dev installations?  It only happens

Web Service for uploading documents into SharePoint

WS UploadService is a web service written for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0 and is meant for uploading documents into SharePoint. I have just uploaded the zip file to GotDotNet.com so it will take some time before the zip file appears in the list of downloads. For the time being, you can download the zip file from the following location

Microsoft Office Excel cannot open or save any more documents because there is not enough available


hi all,

     i am new to asp.net programming i am trying to create an ms excel file with charts drawn in it,

i wrote the complete code for it but the it is saying

Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space. 

i have set the permissions to my complete disk space and all user accounts, and i tried with anti-virus disabling also it didnt work please try to help me out and my code is :

Imports System.Data.OleDb
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Tools.Excel
Imports System

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


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

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