Solved

Nasty error message on Office 2010 saving to SharePoint Foundation 2010

Posted on 2011-02-24
6
2,544 Views
Last Modified: 2012-05-11
Folks:

I have a newly-installed SharePoint 2010 Foundation (as in "FREE") server running.  I have created a test document library and added a couple of columns as mandatory fields.  I can upload files from the actual SharePoint site in my browser, and it prompts me very nicely to add the information for the metadata columns including the mandatory ones.

When I generate a PDF in a product called Nuance PDF Converter and choose its save to SharePoint function, it also nicely prompts me to put in the column info and everything is hunky-dory.

And then there's Microsoft Office.

Ahem.

When I create a document from within a Microsoft Office 2010 app using "File, New" and then choose "File, Save & Send, Save to Sharepoint", browsing to my new document library....I get a very nasty error message across the screen with a big red "X".....and the text:

The file cannot be saved because some properties are missing or invalid.

Use the Document Information Panel to provide the correct property values.  Errors for required properties are marked with a red asterisk, and errors for invalid properties are marked with a red dashed border.

There is a button to go to the Document Information Panel and fix the data but this is a really nasty error message.  I find it ironic that as much as Microsoft touts Office-to-SharePoint integration a third-party app from Nuance does this so much better.

I have read a few articles that suggest changing the characteristics of the content type, in this case the default "Document" content type, to always display the DIP (aptly named IMHO) on save of new documents which is supposed to fix this but of course SharePoint Foundation does not include this, at least not in the GUI.

Is there a way to make this work a lot better than the nasty-looking error message?  I'd be embarassed to roll this out to my users the way it looks now. Error message given in Word 2010 when saving a new file to a SharePoint library with required columns
0
Comment
Question by:CeleritasPrime
  • 4
  • 2
6 Comments
 
LVL 14

Expert Comment

by:GeorgeGergues
Comment Utility
This means you have some required fields that need to be set prior to Check in

So  you will need to hit that (Go to Document Information Panel ) and update the required fields

the best way to do that is to use the server options from the Office Ribbon.


Best of luck .

0
 
LVL 1

Author Comment

by:CeleritasPrime
Comment Utility
I know what it means (I created the library and made the columns mandatory), and those fields do not appear in the DIP.  Remember, this is a newly-created file and so Word has no way of associating it with the fields in the SharePoint library.  

Also, what do you mean by "Server Options from the Office Ribbon"?
0
 
LVL 1

Author Comment

by:CeleritasPrime
Comment Utility
What I am looking for is a way to convince Office to display the DIP and prompt/allow the user to fill in the required fields as a smooth part of the save process rather than have them faced with an error message.  Like I mentioned, the Nuance product does this nicely.  I have found reference to how to change the content type to always display the DIP on the save of a new item, but this option is not available in SharePoint foundation.  My guess is that I will need to manually edit some XML files for the content types on each site collection to make this happen.  Any help?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 14

Accepted Solution

by:
GeorgeGergues earned 500 total points
Comment Utility


I don't think there is a way , to know the required fields before you connect to the site first time ,.
the product you  mentioned actually connects to the site first to get the required columns.

Here are the settings for the DIP
Word options  - > Advanced   - > General  ->  Service Options - >  Document Management Pane

I am sure you can have a Registery change to make that happen but I would not go that far

I am interested to know how this will work.

Best of luck.
0
 
LVL 1

Author Comment

by:CeleritasPrime
Comment Utility
George:

I know there is no way to know the required fields but it would be nice if the DIP popped up to request user input rather than the nasty-looking error message.  Third-party products seem to do this just fine, it's only Office, ironically enough.
0
 
LVL 1

Author Closing Comment

by:CeleritasPrime
Comment Utility
There is no solution to this, unfortunately.  Just really bad design on Microsoft's part on the user experience here.  With all of Microsoft's touting of Office integration with SharePoint this is pretty inexcusable on their part.  Thanks, George, for trying to help, though.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now