ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007: Default Workbook Issue (https://www.excelbanter.com/excel-discussion-misc-queries/213480-excel-2007-default-workbook-issue.html)

illini_99[_2_]

Excel 2007: Default Workbook Issue
 
I created two excel templates and named them book.xltx and book.xltm and
saved it to the following directory:

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

When I first open up Excel, it uses my new default workbook as I can see my
header footer, and other options.

HOWEVER, when I create a new workbook using FileNew or clicking the New
icon, it does not use my default workbook. I always have to click through
the screen and select Blank workbook when I create a new workbook using the
menu item or the toolbar icon.

Any ideas on how to resolve?


Jim Rech[_2_]

Excel 2007: Default Workbook Issue
 
When you do a File, New Excel goes to your Templates folder. If you want it
to use your Book.xltx directly press Ctrl-n instead.

--
Jim
"illini_99" wrote in message
...
I created two excel templates and named them book.xltx and book.xltm and
saved it to the following directory:

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

When I first open up Excel, it uses my new default workbook as I can see
my
header footer, and other options.

HOWEVER, when I create a new workbook using FileNew or clicking the New
icon, it does not use my default workbook. I always have to click through
the screen and select Blank workbook when I create a new workbook using
the
menu item or the toolbar icon.

Any ideas on how to resolve?




illini_99[_2_]

Excel 2007: Default Workbook Issue
 
Thank you very much. That does the trick.

"Jim Rech" wrote:

When you do a File, New Excel goes to your Templates folder. If you want it
to use your Book.xltx directly press Ctrl-n instead.

--
Jim
"illini_99" wrote in message
...
I created two excel templates and named them book.xltx and book.xltm and
saved it to the following directory:

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

When I first open up Excel, it uses my new default workbook as I can see
my
header footer, and other options.

HOWEVER, when I create a new workbook using FileNew or clicking the New
icon, it does not use my default workbook. I always have to click through
the screen and select Blank workbook when I create a new workbook using
the
menu item or the toolbar icon.

Any ideas on how to resolve?






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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com