+ Reply to Thread
Results 1 to 3 of 3

New workbook template not working (365)

  1. #1
    Registered User
    Join Date
    04-18-2007
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    40

    New workbook template not working (365)

    I have a simple template I want to use for all new blank workbooks. I'm led to believe I should save it as "book.xltx" in "the XLSTART folder". Well I have two XLSTART folders:

    C:\Users\me\AppData\Roaming\Microsoft\Excel\XLSTART\

    C:\Program Files\Microsoft Office\Root\Office16\XLSTART\

    I have saved it in both locations, but new books still open without the template.

    I have also tried defining my own location in "Options > Advanced > General > Open all files in" and saving it there, but no luck there either.


    What am I doing wrong?!
    Last edited by shreksbro; 10-23-2021 at 07:19 AM.

  2. #2
    Registered User
    Join Date
    01-16-2015
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    31

    Re: New workbook template not working (365)

    Save this file at this location

    C:\Program Files\Microsoft Office\Root\Office16\XLSTART\

    and Save the excel workbook as "book.xla" (Microsoft Excel Add ins) in "the XLSTART folder"
    Muhammad(APFA)
    Query solved,click Stars...

  3. #3
    Registered User
    Join Date
    04-18-2007
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    40

    Re: New workbook template not working (365)

    Quote Originally Posted by mngrshoaib View Post
    Save this file at this location

    C:\Program Files\Microsoft Office\Root\Office16\XLSTART\

    and Save the excel workbook as "book.xla" (Microsoft Excel Add ins) in "the XLSTART folder"
    Tried, thank you, but without success.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Create a new workbook from a template worksheet using information from main workbook.
    By nathandavies9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2017, 11:28 AM
  2. Macros in a template won't work when template is used in a new workbook
    By benlock17 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-03-2016, 03:45 PM
  3. [SOLVED] Want auto-gen number in template workbook to stop working when saved to normal workbook
    By tjamestx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2014, 02:56 PM
  4. Copying specific rows from workbook containing data to a template workbook
    By mattyp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-18-2014, 10:06 AM
  5. Converting workbook with Macro to a template causes the Macro to stop working
    By Skeeta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2012, 02:00 PM
  6. Macro, copy UNLOCKED cell range of sheet in open workbook to workbook template
    By NicksDad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2012, 11:18 AM
  7. Replies: 3
    Last Post: 07-06-2012, 01:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1