Startup option

M

MS Excel

Hi,

I have a custom template for Excel. Which I want to be opened when ever I
click NEW button in EXCEL.

Any idea
 
M

Mark R Penn

But remember that that will replace your standard "blank workbook" template.
I prefer to keep that, and create fresh shortcuts to other templates I want
to run.

I assume there must be some easy way to get the standard Book.xlt template
back if you do overwrite it?

Mark
 
M

MS Excel

created book.xlt and pased in "C:\Program Files\Microsoft
Office\Office10\XLStart" but invain...it didn't worked...
I had practiced the same in 97 a few years ago.. but in Excel XP its not
working.

Please advise if i am making some mistake...its driving me crazy
 
M

Mark R Penn

Have you tried simply re-directing the "new" button to the template you
want?

Mark

MS Excel said:
created book.xlt and pased in "C:\Program Files\Microsoft
Office\Office10\XLStart" but invain...it didn't worked...
I had practiced the same in 97 a few years ago.. but in Excel XP its not
working.

Please advise if i am making some mistake...its driving me crazy
Click to expand...
 
D

Dave Peterson

Depending on how you upgraded excel, you may have multiple XLStart folders. And
if you have multiple book.xlt throughout those folders, excel may not use the
one you want.

To find the current XLStart that excel wants to use...

open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?application.startuppath
For me (winXP and xl2003), I get:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

Find all the book.xlt files you can (or check each of the XLStart folders you
have).

Close excel
windows start button|search
look for book.xlt
And delete/move/clean up the ones not in the correct location.

(I'd delete all the "wrong" book.xlt's and just keep the one in that folder.)

Then when you click the New Icon on the standard toolbar, you should get a
workbook based on that template file.
 
D

Dave Peterson

There really isn't a standard book.xlt workbook. If you've created a new
book.xlt and stored it in you're XLStart folder and don't want to use it, you
can delete it (or move it to a safe location).

Alternatively, you can click File|New... and choose Blank workbook
(xl2002+ works ok this way--I don't recall about xl2k and below)
 
M

MS Excel

yeah.. it work for single click only.. and after that it don't create new
file..


Mark R Penn said:
Have you tried simply re-directing the "new" button to the template you
want?

Mark
Click to expand...
 
M

MS Excel

Amazingly its working.. I just deleted all book.xlt and did as you
advised... its working..
thanks.
 
Top