Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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





  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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






  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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








  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Default Excel file and template Mark McDonough Excel Discussion (Misc queries) 2 May 26th 06 02:50 AM
How do I set the default to "Open" or "New" for a template Kord Excel Discussion (Misc queries) 6 December 8th 05 01:01 AM
CSV formatted files open odly in Excel 2000 Janski Excel Discussion (Misc queries) 3 November 24th 05 07:58 PM
i try to open Excel spreadsheets, and they open in wordpad-- mikekeat Excel Discussion (Misc queries) 2 October 1st 05 10:13 PM
How to change default printing parameters on Excel & ...... Amjad Excel Discussion (Misc queries) 9 September 7th 05 03:22 PM


All times are GMT +1. The time now is 01:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"