Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lucilene
 
Posts: n/a
Default New button does not open the template workbook set up

Excel 2003 I created a template workbook that contains my cells and page
formatting preferences. When I select New from the File menu I can choose the
template created, but when I click on the New button the workbook does not
reflect the same template formatting. Any ideas?
  #2   Report Post  
Michael
 
Posts: n/a
Default

You have to access templates from the file - new menu, not the new icon on
the standard toobar.
--
Sincerely, Michael Colvin


"lucilene" wrote:

Excel 2003 I created a template workbook that contains my cells and page
formatting preferences. When I select New from the File menu I can choose the
template created, but when I click on the New button the workbook does not
reflect the same template formatting. Any ideas?

  #3   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi lucilene

What is the name of the template and where have you placed it

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


"lucilene" wrote in message ...
Excel 2003 I created a template workbook that contains my cells and page
formatting preferences. When I select New from the File menu I can choose the
template created, but when I click on the New button the workbook does not
reflect the same template formatting. Any ideas?



  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

lucilene

There are two "New" menu items for the "File" menu.

One has an ellipse(...)

The other has no ellipse.

Store your template saved as BOOK.XLT in your XLSTART folder and use the
"New" item without the ellipse.

The resulting new workbook will be based upon your template.

You can also click on the "New" icon on the standard toolbar and create a new
workbook based upon the BOOK.XLT template.


Gord Dibben Excel MVP

On Tue, 19 Jul 2005 09:46:09 -0700, "lucilene"
wrote:

Excel 2003 I created a template workbook that contains my cells and page
formatting preferences. When I select New from the File menu I can choose the
template created, but when I click on the New button the workbook does not
reflect the same template formatting. Any ideas?


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
Open template automatically Yiling Excel Worksheet Functions 1 June 25th 05 05:52 PM
Excel 2003 hangs when trying to locate a workbook to open Darren Hill via OfficeKB.com Excel Discussion (Misc queries) 1 March 24th 05 12:41 PM
Sumif Linking to Another Workbook error #VALUE! Tunde Excel Discussion (Misc queries) 16 March 4th 05 03:02 AM
Macro to simply bring up the Find dialogue box?? marika1981 Excel Discussion (Misc queries) 14 January 14th 05 10:47 PM
Can no open workbook tandem Excel Worksheet Functions 4 December 1st 04 12:45 AM


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

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

About Us

"It's about Microsoft Excel"