Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 6th 05, 03:22 PM
Questions from Christine
 
Posts: n/a
Default Where does Excel get the default properties without startup file?

I do not hav ea startup file in my XLStart folder. When I ask for a new
worksheet, the new file has properties that I need to change everytime.
Where does Excel obtain these properties so I can reset them?

  #2   Report Post  
Old July 6th 05, 07:36 PM
Dave Peterson
 
Posts: n/a
Default

New worksheet or new workbook???

In either case, if you don't have Book.xlt or sheet.xlt in your XLStart folder,
I think that the defaults are buried deep into excel--not changeable by the user
(well, at least not by me!).

But that's what having a book.xlt template (and a sheet.xlt template) in your
XLStart does for you--it allows you to change those defaults.

(Actually, some of the properties of the new workbook can be found in
Tools|options--sheets in new workbook for example in the General tab.)

Book.xlt is used as the template for new workbooks and sheet.xlt is the template
for adding new worksheets to existing workbooks.

Is there a reason you don't want to use one of these templates?

Questions from Christine wrote:

I do not hav ea startup file in my XLStart folder. When I ask for a new
worksheet, the new file has properties that I need to change everytime.
Where does Excel obtain these properties so I can reset them?


--

Dave Peterson
  #3   Report Post  
Old July 6th 05, 07:47 PM
Michael
 
Posts: n/a
Default

Go to Help and type in Template.
--
Sincerely, Michael Colvin


"Questions from Christine" wrote:

I do not hav ea startup file in my XLStart folder. When I ask for a new
worksheet, the new file has properties that I need to change everytime.
Where does Excel obtain these properties so I can reset them?



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
How to set Read-Only Recommended as default save in Excel 2002? flyaj Excel Discussion (Misc queries) 1 April 14th 05 11:04 PM
How can I change the default settings for pivot tables in Excel? . KyWilde Excel Discussion (Misc queries) 0 March 10th 05 12:33 AM
How do I change the excel chart default plot area color? gg96555 Charts and Charting in Excel 2 February 8th 05 08:36 PM
Set "print all text as black" as default in Excel CMK Excel Worksheet Functions 0 January 25th 05 09:31 PM
how would i change default user name all excel files learner Excel Discussion (Misc queries) 1 November 29th 04 11:12 PM


All times are GMT +1. The time now is 09:45 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017