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

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

Publish Office 2007 documents with metadata to SharePoint 2010?

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :SharePoint
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.

View Complete Post

More Related Resource Links

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

Is it possible to define metadata at Office 2007/2010 when saving to the SharePoint 2010 library

I have succesfully saved Excel 2007 document  to the document library. I wonder if it is possible to define meta data with client? Otherwiser end-user need to anyway open the SharPoint library and add metadata information there.  Example metadata is like "category".   Kenny_I

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.

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!

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


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.

Sharepoint Foundation 2010 problems with Office 2007 ActiveX controls

I have a SPF server that I recently upgraded from WSS 3 using the database attach method. The new server configuration is SQL 2008 R2 with SPF 2010 on Windows 2008 64bit SP2. Mostly things are working fairly well, though there have been a few fires to put out. The latest inflamation seems to be centered around ActiveX controls for Office 2007. I'm getting the following message whenever I try to create a new document using the New button: " 'New Document' requires a Microsoft SharePoint Foundation-compatible application and web browser. To add a document to this document library, click the 'Upload Document' button." On the client side, the browser is IE8 on Windows 7 (Windows is 64bit, though the browser is in 32 bit mode.) using Office 2007. I've also had the same problem with systems running XP. In terms of troubleshooting, other activeX related features seem to be working fine. I can open datasheet views, if I click on a document, it will open in the appropriate client. However, I have some libraries where the Word document template opens the document information panel and those will give thhe following message on open: "One or more ActiveX controls could not be displayed because either: 1)Your current security settings prohibit running ActiveX controls on thi page , or 2) You have blocked a publisher of one of the contols. As a result the page mi

Sharepoint 2010 integration with Office 2010, 2007,2003

hi, i am looking, if some one know about the details or link, for the details about the Sharepoint 2010 integration with Office 2003, 2007 and 2010 versions. We will be migrate in couple of months to 2010 but we have mixed flavor of the office version in our environment. We have 2003, 2007 and 2010. Is their any blog post or anyone know what is now possible with 2010 but not in the 2007 or 2003. like a comparison chart.   thanks WSi am at entry level administrator

Sharepoint Managed Metadata Services and Office 2007

Is there a patch or a workaround which would allow you to fill in metadata information pertaining to a column(which is a managed metadata type) from office 2007 client application. Currently it is greyed out and says Edit in server. Thanks KI am what i am

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!

Currency and number column error with office 2007 document formats in SharePoint 2010 library

Hi there,



The following error occurred within a SharePoint 2010 document library:

As I tried to test out the new SharePoint 2010 environment I changed the metadata from a few documents within a document library. I noticed that the data from the currency und number field was incorrect from a few documents. The numbers looked like that the decimal separator were ignored. For an example: 123.456,78 was saved as 12.345.678.

At first I thought it could be a language incompabilty but if that would be the case: Why would there be other documents which show the correct number?


I created another document library to recreate this error. And there I noticed the real reason: Every time I changed these fields from a document which was saved in the office 2007 format the error occurred. The metadata from the documents in the office 2003 format were correct.


Has anyone a similar problem or got an idea how to solve this problem?


System Specs:

Frontend: Windows Server 2008 SP2 ent

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?

How MS Office 2007 & Office 2010 Communicate with SHarePoint



Can any one tell me in detailed. How MS Office 2007 and 2010 communicate with SharePoint 2007 & 2010? Which protocol is used ? How the Versioning, check in checkout is handled.
Please provide me the link or documents.


Thanks, TusharG [There are only 10 types of people in the world: Those who understand binary, and those who don't]

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.


Microsoft Office 2010 compatibility with SharePoint 2007



Can anyone asssist with subject?

We are running our intranet on MOSS 2007 and office 2003

we want to upgrade/replace our current Office suite 2003 to MS office 2010 - are there know issues regarding the compatibility with MOSS 2007 ?


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