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

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.

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

Hi Ben,

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

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

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/

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

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.

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

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.

maybe wrong locations???

File, option, trust center, trusted location.. ( 2010 )