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

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



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




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
Excel 2007, log chart issue Newsx Charts and Charting in Excel 10 August 23rd 08 06:55 PM
Excel 2007 and Name Conflict Issue rykkim Setting up and Configuration of Excel 5 August 5th 08 04:29 AM
Location of default workbook in Excel 2007 hmm Setting up and Configuration of Excel 1 March 9th 08 04:52 PM
Excel 2007 Protect Workbook issue Newbie Excel Worksheet Functions 0 July 17th 07 10:48 PM
Default a workbook to save as a xlsm (macro-enabled) in 2007 Razzer204 Excel Discussion (Misc queries) 3 March 21st 07 06:10 PM


All times are GMT +1. The time now is 12:32 PM.

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"