Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 3rd 05, 12:39 PM
Shady
 
Posts: n/a
Default how to create and use a new spreadsheet based on a template

how do I create and use a new spreadsheet based on a template?

  #2   Report Post  
Old April 3rd 05, 01:21 PM
Don Guillett
 
Posts: n/a
Default

Am I missing something or will filesaveas help you

--
Don Guillett
SalesAid Software

"Shady" wrote in message
...
how do I create and use a new spreadsheet based on a template?



  #3   Report Post  
Old April 3rd 05, 02:53 PM
Jim May
 
Posts: n/a
Default

Do a Search/find on your local C: drive for *.xlt
this should produce any and all excel templates found.
If you don't find any then you will need to "roll-your-own".
Open a fresh workbook - get everything looking the
way you want it - (set the defaults) - then do a File Save As
and
look for a folder under your Excel installation named
XLStart << any *.xlt files in this folder will auto-load as
Excel is opened. save it as an .xlt (type file) in the XLStart folder.
Name it -- Book.xlt
Close out of Excel Completely
Re-open Excel and it should automatically create "Book1" from
your Book.xlt file (which goes undisturbed). Edit Book.xlt as desired
always saving as XLT type.





If you have any *.xlt files that you found copy and paste into
the XLStart folder

You need first to "create" a template if one doesn't exist
"Don Guillett" wrote in message
...
Am I missing something or will filesaveas help you

--
Don Guillett
SalesAid Software

"Shady" wrote in message
...
how do I create and use a new spreadsheet based on a template?





  #4   Report Post  
Old April 3rd 05, 09:50 PM
Fadi Chalouhi
 
Posts: n/a
Default

Hi Shady,

you need to save the template as an .xlt file so that Excel recognizes
that it is indeed an Excel Template. It is recommended to save the
templates in the default directory that Excel provies when you first
select the .xlt option in the Save As dialog.

After you save your template, goto File-- New and you should see your
newly created template there.

HTH

Fadi Chalouhi
http:\\www.chalouhis.com\XLBLOG

On Sun, 3 Apr 2005 04:39:01 -0700, "Shady"
wrote:

how do I create and use a new spreadsheet based on a template?


HTH

Fadi Chalouhi
http://www.chalouhis.com/XLBLOG


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



All times are GMT +1. The time now is 04:41 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017