0

This document library have a excel template, so every time a user clicks on new and selects the template book.xlsx gets created. Is there any possibility to change this default name to something else then "Book" once it gets created?

If not is there any work around?

1

I haven't found a way to change the initial name, the user would have to change the name to something useful/unique when saving.

However, I do have a rough fix of a workflow which when a new document is created and saved and the user has closed the document (so they don't still have it checked out) it renames the document. This is just done with the set field value for 'name' on current item.

Not the cleanest but works reliably. Would this solve your problem?

  • Yes that would be very greatful! – Rohander Mar 12 at 12:25
0

I found that the file name of an excel file is what the file name defaults to when you create a new document from the template.

Here is a screen shot of a library where I turned on content types and then uploaded an excel file named Excel File Name. As you can see when I went to the library and used the new button to open the template that the file name defaults to what the template file name was.

  1. Upload your excel template with the file name being what you want to default.
  2. After the template is saved the file name appears here.
  3. Example of selecting Save As from the template applied to this library.
  4. The default file name in the save as box comes from the file name.

enter image description here

By the way I found that Word documents take the first line of text in the document for the default file name of a new file.

  • Thanks for the answer, but the user are using the web version of excel in SharePoint and when you use "Save As" the default becomes book.xlsx no matter what. – Rohander Mar 12 at 12:34
  • Sorry about that, I'm using SharePoint 2013 on prem with Office 2016. – Chris G Mar 12 at 13:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.