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


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

Cannot Use Excel Spreadsheet (xlsx) as Template for Content Types or Document Libraries

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :SharePoint
 

I have created a document library, specifying that the 'Microsoft Excel Spreadsheet' be used as the document template.  When I try to create a new document by selecting the template from the 'new Document' drop down, I get a message stating that 'The document could not be created.  The required application may not be installed properly, or the template for this document library cannot be opened.' Additionally, the template is opened as template[1].xltx in notepad (with all of the funny characters you would expect).

I have Office Professional Plus 2010 installed on my computer, and I am able to open XLSX and XLTX files from SharePoint (just not from the 'new document' button).  I also have no problem with PowerPoint or Word templates in SharePoint. I am also able to open the excel template by navigating to the template in explorer view.  I've found that if I open Excel before I attempt to create a new document, the template will open in Excel, however the document is titled 'Template1' instead of 'Document1' as would be expected.  Any thoughts?




View Complete Post


More Related Resource Links

Moving Document Libraries with Content Types & Metadata

  

Hello All,

Was hoping someone could give me some guidance on this issue.  I have been working on a document management strategy for my department's sharepoint site which consists of numerous document libraries configured to a number of content types..  Lots of metadata and views.. etc

Recently, the IT department in our organization has started work on a green slate installation of Sharepoint.. new server, fresh install, master pages, site hierarchy, the works..  

Guess my question is, how hard is it going to be to migrate my document libraries  while keeping my metadata and content types intact?  I probably have about 21 content types and almost 10 Gigs of data to transfer over... not sure what the best approach is having all this content migrated over to the new portal.

I have done some research and either only find articles on moving content types or moving document libraries, but no articles on moving both and having the content types map to the document libraries while keeping the metadata.

Any help or guidance would be appreciated.

Greg


Add new content types to multiple libraries

  

We use MOSS for document management and content types for document types (i.e. specification, quote, PO etc.)).  We would like to add additional content types to our libraries.  I was hoping to find a tool that would help me to propagate these new content types ad I am not a programmer.

 

 


Document Library "export to spreadsheet" doesn't export all columns in Excel 2003

  
Hi, we are working with MOSS 2007, Infopath Forms Services, KPIs and Excel 2003. There is a view for some data of the Infopath forms which has to be exported to Excel by our users, but some columns are not exported - without any error message. If I try to export it to Excel 2007 everything is exported as expected, but our users have to use Excel 2003. Any idea?

Files in document libary not picking up the correct content types

  
Hi, I have a document libary where I have 10 InfoPath content types attached. For eg: Type1, Type2 etc... Type10. In this doc lib, I have a folder for each cutomer, and inside each of those folders, I have a file of each Content type (".xml"). I am creating these Folders and files programatically. The problem is that, the files are not picking up its content types. Every file (.xml), when uploaded, its content type is "Document" which is the default content type. Earlier it used to pickup the correct content types. What could be wrong?

How To "Upload a new document template" to Content Type via Web Service

  
I hope someone can help me. Let me begin by saying that I'm not a programmer; so I 'may' not get the terminology exactly right, but hopefully someone will know what I mean. I am using SharePoint 2010 along with a 3rd party application that I'm using for creating, managing and executing workflows.  The workflow application I'm using is Nintex Workflow 2010.  As such, I can only use functions, services, commands...etc...that are offered to me by that application. Anyway, what I am trying to do is simply replace a document template that is being used for a particular content type with another document template. For this I believe I need to use the Webs.UpdateContentTypeXmlDocument Method.  More information is provided here (http://msdn.microsoft.com/en-us/library/websvcwebs.webs.updatecontenttypexmldocument.aspx). The Webs.UpdateContentTypeXmlDocument method requires two parameters..."contentTypeId" and "newDocument". "contentTypeId" - I have got the Content Type ID by clicking on the content type and viewing the URL shown in my browser.  So, I am confident that my content type id is correct and is "0x010100C392CF11DE923A4E8AB9018B0A42119303". "newDocument" - The MSDN article states...'A string that represents the XML document to replace the existing XML document.".  To be honest, I'm not 100%

Files in document libary not picking up the correct content types

  
Hi, I have a document libary where I have 10 InfoPath content types attached. For eg: Type1, Type2 etc... Type10. In this doc lib, I have a folder for each cutomer, and inside each of those folders, I have a file of each Content type (".xml"). I am creating these Folders and files programatically. The problem is that, the files are not picking up its content types. Every file (.xml), when uploaded, its content type is "Document" which is the default content type. Earlier it used to pickup the correct content types. What could be wrong?

XsltListViewWebPart: Document Library with Content Types

  
Good Morning, I have a requirement to add a webpart from a parent site to a child site to display a document library list view web part. Site structure eg: /parent/DocumentCenter /parent/ChildSite I have followed the instructions below as per http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/05c2c386-b6f3-4a4b-9641-e46d5bb3d4c2; 1) Open the parent site in SPD 2010.  2) Select "Lists and Libraries" from the left navigation pane 3) Select a list 4) In the "Views" section on the right, either open an existing view (e.g. AllItems.aspx) or create a new view. 5) In SPD page editor, click on the view. 6) In the Ribbon UI, go to List View Tools -> Web Part tab 7) Click "To Site Gallery" from "Save Web Part" section. 8) Give it a name and description (e.g. "ParentA") 9) Click "Yes" when the message pops up.  This ensures that the web part will point to the original source (i.e. main site) 10) In the browser, go to your subsite 11) Edit the page, insert web part through the browser ribbon. 12) Go to Miscellaneous section, and select the web part you saved. I have found if the document library is set to 'Allow Management of Content Types' the web part added to the child site will fail with the below error "Value does not fall within the expected range". As soon as i rem

Make Document Content Types visible in search results

  
How do I make the document content type show in the search results? so when I search for something I get back the content type along with the usual title, summary, urls, size etc. thx    

MOSS 2007 Strange Problem with edit forms, content types and document library columns

  

I'm having a strange problem and have not been able to track down any useful answers over google.

I inherited a SharePoint site that I am now making some changes to.

I am having problems with one document library.  We had custom edit forms on this document library, which I was finding a pain to maintain so I reset them back to the site definition.  This edit form now shows only those fields that are associated with the Document content type (the only content type - I've deleted the others) on the document library.  There are other columns on this document library that are NOT associated with the content type that I would like to show on the edit form but they are not available when I try to add them to the content type via Settings > Document Content Type > Add from existing site or list columns.  The select columns from drop down is set to List Columns.  The Additional Authors column is just not there.

I CAN see this field on the all items view for the document library, it is there and populated with data.

Setting the Allow Managed content types radio button to NO does not have any impact on which fields are visible on the form- I still see those same fields that have been associated with the Document content type.

Has anyone else seen this or does anyone have any thoughts?? 

They will be muc

Excel new document template opens in Notepad

  

I have a document library with a custom document template. The template is an .XLTX file that I created using Excel 2010. It is associated to the library via a custom content type.

The template worked without any problems for at least a couple of weeks. Then, about a week ago, SharePoint started issuing the following warning when trying to create a new document using the template:

"The document could not be created. The required application may not be installed properly, or the template for this document library cannot be opened. Please try the following:

  1. Check the General Settings for this document library for the name of the template, and install the application necessary for opening the template. If the application was set to install on first use, run the application and then try creating a new document again.

  2. If you have permission to modifyu this document library, go to General Settings for the library and configure a new template."

This issue happens for myself, and some of my colleagues but not everyone. It happens on both SharePoint 2007, and 2010. We all have MS Office 2010 (32-bit) installed on our client machines. I have already tried changing the file extension application association for .XLS, .XLSX, .XLTX and .XLT to make extra sure that they are all pointing to Excel 2010. It didn't

External Data Fields in a Word Template saved as a content type in a document library with multiple

  

I have created a Word Template for a Document Library that has an External Data Column in it of Client Name which also adds Client Address1, Client Address2, Client City, Client State, & Client Zip.  Now this works fine for a Document library with that template as the Template.dotx file. 

I want to be able to make a bunch of Templates and have them all as Content Types in one Library.  When I do this I cannot get the External Data Quick Parts to work.

Anyone have any ideas?


Custom document library list template issues with custom content type

  

Either I don't know what SharePoint is doing or I don't know what I'm doing (or both, which is more likely).

I'm attempting to create a Custom Document Library template with a custom content type association (Custom Document), all using a feature. When I create
a document library based on the installed template, the content type association is there. However, when I click on New Custom Document, the template.dotx does not reflect the Custom Document content type association. The Word document information panel does not show any Custom Document content type properties (like Title and Comments).

Here are the steps I've taken:

1. Create the feature.xml with element manifests of contentType.xml and CustomDocumentLibrary.xml
2. Create the contentType.xml (Custom Document) with an additional field reference for Comments
3. Create the CustomDocumentLibrary.xml for the list template
4. Create a Custom Document Library subfolder that contains the same files that are in the 12\TEMPLATE\FEATURES\DocumentLibrary\doclib folder.
5. Edit the schema.xml to use the new content type and field reference
6. Deploy and activate the feature
7. Create a new "Custom Document Library"
8. Go to Custom Document Library Settings and verify the Custom Document content type is being used
9. Click on New Custom D

not open excel 2010 file template in moss 2007 document library

  

I have installed microsoft sharepoint portal server 2007.

In which I specify in one document library excel template. I upload template of excel 2010

if OFFICE 2007 is installed in my system or in other persons . then it will open a template in excel document . but I update office and now office 2010 installed in my system. now when i click a new button and open a excel document . it is not opening and open only a text file with garbage. and show a dialog box with message.

 

"The document could not be created.

The required application may not be installed properly, or the template for this document library cannot be opened."

How can I open a template in office 2010 with MOSS 2007 document library.

Kindly tell me the solution as soon as possible.

 

 


Basim Alvi

Content Type Properties/Fields on Document Template

  

I have created a content type and added some custom site columns to it.  I have also created a document template (.dotx) where I have added some of the columns as fields that appear in the footer and header of the document template.  In the Advanced Settings of my Content Type I have added the .dotx template as the template for the Content Type.

In a document library I added the content type.  When I create a document from the content type in that document library the fields on the new document do not get updated when I select different data for any of the columns in the Document Information Panel.

Even when I save the document and reopen it the data in the columns on the Header or Footer does not get updated so there is a discrepancy between the data selected on the DIP and what is shown in the Header or Footer.

What am I doing wrong?


SharePoint 2010 Event Receiver verifying Content Types inside Document Sets

  

I have a document library and document set is added as one of the content types. The user goes inside the document set and inside the document set, I have 2 different content types. Now my scenario is that, one of the content types - which is referred as Main Report should not be used twice. I mean, within the document set, only one document of Main Report content type should exist. How can we do this?


Karthick

Custom Content Type is missed while restoring Document Libary template

  

Hi,

I have a document library and i use a custom template "templateA" in it,This also inherits from "Folder" content type. When i'm restoring this template backup file to a new library,It missed the content type "templateA" and appears as "Folder" in all items.

I use a publishing site, and i created the content type in site level, I also created the document library in sub site level where i used the template,

Is there any work arround to get the custom content type in restored Libray.I use moss 2007.

Thanks,
Susant


How to show icons for different file types inside Document Libraries

  
I would like to know how i can tell sharepoint to show a special icon for a defined file type?
Best regards,
Yavuz B.

My Sharepoint and Enterprise 2.0 Blog http://www.starcoder.net | Microsoft Sharepoint Resources & Blogs List
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