Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
Max
 
Posts: n/a
Default how do I change the deafault workbook in Excel?

None of the ways suggested in various manuals work. I've tried to create the
following files in different folders (XLSTART, TEMPLATES, etc.):
- book.xlt and xls
- workbook.xlt and xls

but Excel does not recognise them as a default tepmlate for new workbooks

help please
  #2   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default how do I change the deafault workbook in Excel?

Max

The Blank workbook that opens using File New...(note ellipsis)Blank Workbook
is not the BOOK.XLT you stored in the XLSTART folder.

I use the other FileNew command(the one without the ellipsis...) or the New
File button on the Toolbar. Either of those will give you your default
BOOK.XLT directly from your XLSTART folder.

If not on your File Menu, go to ToolsCustomizeCommandsFile and drag the
"New" command to the File Menu.

Check out the descriptions of the two "New" commands while you're there. You
will see the difference between the two.

Also check out this search thread............watch out for line-wrap.

http://groups.google.com/group/micro...6a5de5e0f9dc9f


Gord Dibben Excel MVP




On Wed, 29 Mar 2006 23:09:02 -0800, Max wrote:

None of the ways suggested in various manuals work. I've tried to create the
following files in different folders (XLSTART, TEMPLATES, etc.):
- book.xlt and xls
- workbook.xlt and xls

but Excel does not recognise them as a default tepmlate for new workbooks

help please


Gord Dibben MS Excel MVP
  #3   Report Post  
Posted to microsoft.public.excel.setup
Max
 
Posts: n/a
Default how do I change the deafault workbook in Excel?

Thanks a lot, Gord. It appears that no way one can easily replace the
"standard-standard" template

"Gord Dibben" wrote:

Max

The Blank workbook that opens using File New...(note ellipsis)Blank Workbook
is not the BOOK.XLT you stored in the XLSTART folder.

I use the other FileNew command(the one without the ellipsis...) or the New
File button on the Toolbar. Either of those will give you your default
BOOK.XLT directly from your XLSTART folder.

If not on your File Menu, go to ToolsCustomizeCommandsFile and drag the
"New" command to the File Menu.

Check out the descriptions of the two "New" commands while you're there. You
will see the difference between the two.

Also check out this search thread............watch out for line-wrap.

http://groups.google.com/group/micro...6a5de5e0f9dc9f


Gord Dibben Excel MVP




On Wed, 29 Mar 2006 23:09:02 -0800, Max wrote:

None of the ways suggested in various manuals work. I've tried to create the
following files in different folders (XLSTART, TEMPLATES, etc.):
- book.xlt and xls
- workbook.xlt and xls

but Excel does not recognise them as a default tepmlate for new workbooks

help please


Gord Dibben MS Excel MVP

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
custom color palette does not get transferred with the workbook. Excel 2003 libra2222 Excel Discussion (Misc queries) 3 December 2nd 05 01:02 AM
Excel 2002 - Why does 1 workbook open as 2 versions B. Levien Excel Discussion (Misc queries) 2 September 30th 05 02:34 PM
HOW DO I CHANGE THE ORDER OF THE SHEETS IN EXCEL WORKBOOK? joanbaer New Users to Excel 4 August 5th 05 09:23 PM
How do I change the default font in an EXISTING Excel workbook? Blueski Excel Discussion (Misc queries) 1 December 29th 04 10:21 PM
Macro in Excel 2002 to save a workbook to a FTP location Lloyd Excel Discussion (Misc queries) 0 December 21st 04 02:49 PM


All times are GMT +1. The time now is 02:46 PM.

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"