Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


New documents based on content type in browser

Posted on 2014-02-19
Medium Priority
Last Modified: 2014-03-18
Office 365 SharePoint online, Small Business Premium plan.

I created a new doc lib using spreadsheet as it's class rather than word doc. I replaced the default excel template file with one that I uploaded. When someone chooses file/new document from the ribbon, it opens the correct new custom template, but it will not do that in the browser, it has to do it in the client. However, the file can be edited in the browser after created in client and then saved to SharePoint. Is there any way possible for users to create a new excel doc with this template in the browser so that everyone doesn't have to have excel in order to create new docs using the library template? I thought that was the purposes of excel services, and as far as I can tell I have those enabled if I can ever see the doc in the browser at all.
Question by:BobHavertyComh
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 1500 total points
ID: 39872809

I don't understand this:

>> When someone chooses file/new document from the ribbon, it opens the correct new custom template, but it will not do that in the browser, it has to do it in the client.

So, does the correct template get opened? If so, what's the problem? If not, is there an error message? What do you mean by "it will not do that in the browser"?

If the template is a Word template, what do you expect to happen? And what happens instead?

If the template is an Excel template, what do you expect to happen? And what happens instead?

Please describe what happens on your system and then describe what you would want to see instead.

Author Comment

ID: 39879180
Hi Teylyn, to put it shortly, I want users to not have to have excel in order to create and work with excel spreadsheets in SharePoint. We have an expense report form done in excel. This was added to the SharePoint library as the primary content type. When users go to create a new expense report by clicking new document on the ribbon, this will not open in the browser and instead needs to open in client. However, with the default, out of the box, content type, which is an empty word doc or excel doc, it allows you to create new ones in the browser. I want it to do the same thing with my content type. If all users need excel client to fill out expense reports, it defeats the claim that excel services means that people don't need excel and only the designer of the template needs it.

Author Closing Comment

ID: 39937861
It has to do it in the client when using Excel, but if I create an infopath form, it allows new entries in the browser.

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

618 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