+ Reply to Thread
Results 1 to 17 of 17

Excel 2010 default Template BOOK.XLT(M)

  1. #1
    Registered User
    Join Date
    03-05-2011
    Location
    Barcelona, Spain
    MS-Off Ver
    Excel 2003
    Posts
    27

    Excel 2010 default Template BOOK.XLT(M)

    Hi,

    I'm struggling with an issue which is very simple as far as Excel 2003 is concerned.
    In "2003" I had a BOOK.XLT template saved in:
    C:\Program Files\Microsoft Office\OFFICE11\XLSTART and whenever I launched Excel and/or opened a new WB the BOOK.XLT was automatically launched.


    Now, in "Excel 2010", I can't get it to work.

    I tried to save it in all types: BOOK.XLT, XLTX, XLTM and in all the folders named: XLSTART
    – but no avail.

    Could you please explain, in detail, what I need to do in order to get it work EXACTLY as it used to work in "2003".

    Thanks, Ben
    Last edited by Benjamin1; 09-13-2011 at 02:00 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,876

    Re: Excel 2010 default Template BOOK.XLT(M)

    Hi ,

    Does this link help?
    http://www.brighthub.com/computing/w...les/27366.aspx
    and
    http://technet.microsoft.com/en-us/l.../cc179039.aspx

    I think 2010 Office is version 14 instead of 12.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-05-2011
    Location
    Barcelona, Spain
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Excel 2010 default Template BOOK.XLT(M)

    Thanks, Marvin,

    I was successful to accomplish it in "Excel 2007".

    In "2010" not only the BOOK.XLTX does not open - when I launch Excel no blank sheet is presented.

    Excel launches and a gray screen shows up. That's all.

    If I want to work on a blank WS I have to press the New Icon.

    In my previous versions - Excel always started with an empty WS or with the default book.xlt(x).

    What went wrong with my "2010" ?

    ************************* EDITED *******************************

    Small progress:

    After deleting ALL the PERSONAL.XLS files - "Excel 2010", now launches with an empty WB but it does not rely on the Book.xltx like his younger brother "Excel 2007" which is installed on a different computer.

    Ben
    Last edited by Benjamin1; 09-13-2011 at 05:13 PM.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,876

    Re: Excel 2010 default Template BOOK.XLT(M)

    Hi Ben,

    Look at File - Options - Save using yor 2010 version.
    I wonder if any of these locations are messing you up?

  5. #5
    Registered User
    Join Date
    03-05-2011
    Location
    Barcelona, Spain
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Excel 2010 default Template BOOK.XLT(M)

    Hi,

    The SAVE section looks exactly the same like in my other computer running "Excel 2007".

    Upon launching my "Excel 2007" not only does it launch the BOOK template WB, it adds adds a new WB - relying on the template - with every hit on CTRL+N.

    CTRL+N in "2010" adds a BLANK(!) WB.

    In my grief I ran "Repair" via the Control Panel but no avail.

    (OS is "Windows 7 Ultimate" 32 bit + SP1)

    I hope you have more suggestions.

    Thanks, Ben
    Last edited by Benjamin1; 09-13-2011 at 06:15 PM.

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,876

    Re: Excel 2010 default Template BOOK.XLT(M)

    Hi Ben,

    Here is another claim on where this file should be located.
    http://www.bettersolutions.com/excel...A748890521.htm
    Here is another thread on the topic
    http://www.dailydoseofexcel.com/arch...es-on-startup/
    Last edited by MarvinP; 09-14-2011 at 01:36 AM.

  7. #7
    Registered User
    Join Date
    03-05-2011
    Location
    Barcelona, Spain
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Excel 2010 default Template BOOK.XLT(M)

    Thanks, Marvin.

    Unfortunatelly, no progress what so ever.

    I read, all the links, very carefully and tried everything.

    I even copied the BOOK.XLTX from my "Excel 2007" machine to the same folder in the "2010" Machine but no avail.

    If I double click that file it opens OK.

    What else can be done ?

    Ben

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,876

    Re: Excel 2010 default Template BOOK.XLT(M)

    Hi Ben,

    I worked on this problem a while yesterday also. I saved to all places on my hard drive that had folders named XLSTART. I also read the RegEdit link and looked at it to see if I could figure out why I couldn't save a .xlsx as a .xltx and not have it be my default template. I guess it's time to ask Microsoft where they hid that default template.

    Maybe we just aren't understanding what is supposed to happen when we open a new .xlsx by double clicking Excel in the start menu.

    What does the warning mean on this link? Are we thinking it will do something it won't
    http://social.msdn.microsoft.com/For...a-a9c6e156dd4e

  9. #9
    Registered User
    Join Date
    03-05-2011
    Location
    Barcelona, Spain
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Excel 2010 default Template BOOK.XLT(M)

    Hi, Marvin,

    From your last reply, can I assume that you face/suffer from the same problem like mine ?

    Ben

  10. #10
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,876

    Re: Excel 2010 default Template BOOK.XLT(M)

    Hey Ben,

    I've found the answer on page 85 of John Walkenbach's Excel 2010 Power Programming with VBA. I hate to plagiarize but here is what he claims.

    1. Open a new workbook.
    2. Make it like you want, fonts, etc
    3. File Save As .xltx with a filename of book.xltx
    4. Save it in your \XLStart folder (not the Templates folder)

    Tip - Find the correct \XLStart by dong a vba of MsgBox Application.StartupPath

    I like Walkenbach's programming style and highly recommend his work.

  11. #11
    Registered User
    Join Date
    03-05-2011
    Location
    Barcelona, Spain
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Excel 2010 default Template BOOK.XLT(M)

    Hi, Marvin,

    Thanks for your reply.

    I checked the proposal and save a Book.xltx (after adding some words) in the following path.

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

    I also deleted all other Book.xltx that were found in drive C.

    Still same problem. Excel launches with an empty Sheet.

    Ben
    Last edited by Benjamin1; 09-18-2011 at 06:12 AM.

  12. #12
    Registered User
    Join Date
    02-16-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Excel 2010 default Template BOOK.XLT(M)

    Guys try this

    Open excel file
    Do what ever the changes you want with paper size also A4
    Save as PERSONAL.xlsb (Excel Binary Workbook)
    Close Excel
    Save the file on desktop then cut paste it to
    C:\Users\your profile\AppData\Roaming\Microsoft\Excel\XLSTART
    Open excel

  13. #13
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Excel 2010 default Template BOOK.XLT(M)

    The book.xltx approach does work in 2010. If it is not working for you then the only reasons I can think of are:
    1. It is in the wrong place. Try adding a normal workbook to the same folder and see if that opens.
    2. Your Excel shortcut has a startup switch that prevents starting with a new workbook.
    3. Your template is listed in the disabled items.

    If ctrl+n does not use the template, then 1 or 3 are most likely.
    Good luck.

  14. #14
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: Excel 2010 default Template BOOK.XLT(M)

    maybe wrong locations???

    File, option, trust center, trusted location.. ( 2010 )
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  15. #15
    Registered User
    Join Date
    09-14-2012
    Location
    Brussels
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Excel 2010 default Template BOOK.XLT(M)

    Hi,

    The Tip - Find the correct \XLStart by dong a vba of MsgBox Application.StartupPath
    made sure that I worked in the right directory

    c:\Users\gifra\AppData\Roaming\Microsoft\Excel\XLSTART

    Then I copied a bunch of renamed files, and looked what worked.
    Clearly all the previous didn't work, but I found a language dependant name:

    Werkmap1.xlsb

    If you copy new files, restart excel or it won't see them.

    Thanks for the pointers

  16. #16
    Registered User
    Join Date
    01-09-2013
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    1

    Re: Excel 2010 default Template BOOK.XLT(M)

    Hi there,

    For Excel 2010, I found that putting the default workbook here works: C:\Program Files\Microsoft Office\OFFICE11\XLSTART
    It does NOT work to put it into C:\Program Files\Microsoft Office\Office14\XLSTART.

    For the default worksheet, put it here: C:\Users\<your-login-name>\AppData\Roaming\Microsoft\Excel\XLSTART
    <your-login-name> -- replace with your Windows login name

    BTW, to have only 1 sheet in the default workbook, go to File > Options > General and change 'Include this many sheets'.

    Clear as mud, isn't it?!?

    - Sally

  17. #17
    Registered User
    Join Date
    09-15-2017
    Location
    Melbourne
    MS-Off Ver
    2010
    Posts
    1

    Unhappy Re: Excel 2010 default Template BOOK.XLT(M)

    Hi, I have the exact same problem. I am an experienced user and have been using Excel for 20 years now. I have used sheet.xls in many versions, all of which have worked perfectly.

    I have tried every suggestion in this forum and nothing works: my personal.xlsb loads, my new sheets come from sheet.xltx, but Excel refuses to open with a book derived from book.xltx !!!

    Any help gratefully accepted.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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