Book.xlt in doesn't open as default
 

I created a template with corporate fonts headers footers etc & called it
Book.xlt

My MS Office template path is c:\DATA\templates and my Normal.dot and
Blank.pot both work fine.

But my default spreadsheet is not my Book.xlt

PS There is nothing in my C:\Program Files\Microsoft Office\Office10\XLStart

I am completely stumped
Can Anyone out there help

Book.xlt in doesn't open as default
 

hi Laura

Copy it in your Xlstart folder

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Laura_lsmarketing" wrote in message
...
I created a template with corporate fonts headers footers etc & called it
Book.xlt

My MS Office template path is c:\DATA\templates and my Normal.dot and
Blank.pot both work fine.

But my default spreadsheet is not my Book.xlt

PS There is nothing in my C:\Program Files\Microsoft Office\Office10\XLStart

I am completely stumped
Can Anyone out there help

Book.xlt in doesn't open as default
 

Try moving your book.xlt to that XLStart folder.

Laura_lsmarketing wrote:

I created a template with corporate fonts headers footers etc & called it
Book.xlt

My MS Office template path is c:\DATA\templates and my Normal.dot and
Blank.pot both work fine.

But my default spreadsheet is not my Book.xlt

PS There is nothing in my C:\Program Files\Microsoft Office\Office10\XLStart

I am completely stumped
Can Anyone out there help

--

Dave Peterson

Book.xlt in doesn't open as default
 

Note : If you right click on your desktop and choose New...Excel document it use the file in

C:\WINDOWS\ShellNew


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
hi Laura

Copy it in your Xlstart folder

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Laura_lsmarketing" wrote in message
...
I created a template with corporate fonts headers footers etc & called it
Book.xlt

My MS Office template path is c:\DATA\templates and my Normal.dot and
Blank.pot both work fine.

But my default spreadsheet is not my Book.xlt

PS There is nothing in my C:\Program Files\Microsoft Office\Office10\XLStart

I am completely stumped
Can Anyone out there help

Book.xlt in doesn't open as default
 

And don't click on FileNew...Blank workbook which will bring up the default
workbook.

Use FileNew(no ellipsis) or New File Toolbar button.


Gord Dibben MS Excel MVP

On Mon, 03 Jul 2006 15:18:06 -0500, Dave Peterson
wrote:

Try moving your book.xlt to that XLStart folder.

Laura_lsmarketing wrote:

I created a template with corporate fonts headers footers etc & called it
Book.xlt

My MS Office template path is c:\DATA\templates and my Normal.dot and
Blank.pot both work fine.

But my default spreadsheet is not my Book.xlt

PS There is nothing in my C:\Program Files\Microsoft Office\Office10\XLStart

I am completely stumped
Can Anyone out there help

Book.xlt in doesn't open as default
 

Thanks Ron

What I don't understand is why I can change my default MS Office template
folder and it works for Word and PowerPoint but not Excel. I'm rolling a
suite of templates out to 500 colleagues and really only want everyone to
have to change one setting and have one folder of templates. It is not very
user friendly to have people faffing about with template and start up folders?

But I appreciate the speedy response

Laura
:-)

"Ron de Bruin" wrote:

Note : If you right click on your desktop and choose New...Excel document it use the file in

C:\WINDOWS\ShellNew


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
hi Laura

Copy it in your Xlstart folder

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Laura_lsmarketing" wrote in message
...
I created a template with corporate fonts headers footers etc & called it
Book.xlt

My MS Office template path is c:\DATA\templates and my Normal.dot and
Blank.pot both work fine.

But my default spreadsheet is not my Book.xlt

PS There is nothing in my C:\Program Files\Microsoft Office\Office10\XLStart

I am completely stumped
Can Anyone out there help

Book.xlt in doesn't open as default
 

Thanks Dave

I know it will work there but the MS Excel help dialogues imply it should
also work in my default template folder. So what I don't understand is why I
can change my default MS Office template folder and it works for Word and
PowerPoint but this does not apply to Excel. I'm rolling a suite of
templates out to 500 colleagues and really only want everyone to have to
change one setting and have one folder of templates. It is not very user
friendly to have people faffing about with template and start up folders is
it?

Thanks for trying to help so quickly though

Laura
:-)

"Dave Peterson" wrote:

Try moving your book.xlt to that XLStart folder.

Laura_lsmarketing wrote:

I created a template with corporate fonts headers footers etc & called it
Book.xlt

My MS Office template path is c:\DATA\templates and my Normal.dot and
Blank.pot both work fine.

But my default spreadsheet is not my Book.xlt

PS There is nothing in my C:\Program Files\Microsoft Office\Office10\XLStart

I am completely stumped
Can Anyone out there help

--

Dave Peterson

Book.xlt in doesn't open as default
 

If you're distributing a specific template to your user group, then I wouldn't
name it book.xlt. I'd let the users have their own default workbook template.

I'd use a different name (several names) and put them in the a common network
folder (if everyone has access to that common network folder).

You can change this workgroup folder via MSWord.
Tools|options|File Locations tab
change the Workgroup templates location

Laura_lsmarketing wrote:

Thanks Dave

I know it will work there but the MS Excel help dialogues imply it should
also work in my default template folder. So what I don't understand is why I
can change my default MS Office template folder and it works for Word and
PowerPoint but this does not apply to Excel. I'm rolling a suite of
templates out to 500 colleagues and really only want everyone to have to
change one setting and have one folder of templates. It is not very user
friendly to have people faffing about with template and start up folders is
it?

Thanks for trying to help so quickly though

Laura
:-)

"Dave Peterson" wrote:

Try moving your book.xlt to that XLStart folder.

Laura_lsmarketing wrote:

I created a template with corporate fonts headers footers etc & called it
Book.xlt

My MS Office template path is c:\DATA\templates and my Normal.dot and
Blank.pot both work fine.

But my default spreadsheet is not my Book.xlt

PS There is nothing in my C:\Program Files\Microsoft Office\Office10\XLStart

I am completely stumped
Can Anyone out there help

--

Dave Peterson


--

Dave Peterson

Book.xlt in doesn't open as default
 

What I don't understand is why

There are more things i not understand <g

I agree with you that it is not user friendly

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Laura_lsmarketing" wrote in message
...
Thanks Ron

What I don't understand is why I can change my default MS Office template
folder and it works for Word and PowerPoint but not Excel. I'm rolling a
suite of templates out to 500 colleagues and really only want everyone to
have to change one setting and have one folder of templates. It is not very
user friendly to have people faffing about with template and start up folders?

But I appreciate the speedy response

Laura
:-)

"Ron de Bruin" wrote:

Note : If you right click on your desktop and choose New...Excel document it use the file in

C:\WINDOWS\ShellNew


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
hi Laura

Copy it in your Xlstart folder

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Laura_lsmarketing" wrote in message
...
I created a template with corporate fonts headers footers etc & called it
Book.xlt

My MS Office template path is c:\DATA\templates and my Normal.dot and
Blank.pot both work fine.

But my default spreadsheet is not my Book.xlt

PS There is nothing in my C:\Program Files\Microsoft Office\Office10\XLStart

I am completely stumped
Can Anyone out there help

Book.xlt in doesn't open as default
 

I get no success with the Office\XLSTART folder.

I stick my BOOK.XLT in

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART


Gord

On Mon, 03 Jul 2006 13:40:14 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

And don't click on FileNew...Blank workbook which will bring up the default
workbook.

Use FileNew(no ellipsis) or New File Toolbar button.


Gord Dibben MS Excel MVP

On Mon, 03 Jul 2006 15:18:06 -0500, Dave Peterson
wrote:

Try moving your book.xlt to that XLStart folder.

Laura_lsmarketing wrote:

I created a template with corporate fonts headers footers etc & called it
Book.xlt

My MS Office template path is c:\DATA\templates and my Normal.dot and
Blank.pot both work fine.

But my default spreadsheet is not my Book.xlt

PS There is nothing in my C:\Program Files\Microsoft Office\Office10\XLStart

I am completely stumped
Can Anyone out there help