Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brett Romero
 
Posts: n/a
Default Why create a template?

What is the difference in creating a spreadsheet vs. a template for
something, then later using that same spread sheet with different numbers
and saving it under a different name? How is a template more beneficial
here?

Thanks,
Brett


  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Why create a template?

For me, as long as I know that the original .xls workbook won't be overwritten
(marked as ReadOnly in windows explorer???), I don't see any significant
difference between a .xlt template workbook and a .xls workbook.



Brett Romero wrote:

What is the difference in creating a spreadsheet vs. a template for
something, then later using that same spread sheet with different numbers
and saving it under a different name? How is a template more beneficial
here?

Thanks,
Brett


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Brett Romero
 
Posts: n/a
Default Why create a template?

Let's say I'm working with two spreadsheets. One of them I keep updating
and improving. How do I implement these changes into the older spreadsheet?
If basically the same format except now I have cells turning different
colors based on conditionals, I'm checking for division by zero, I've
formatted cell length and width and changes text colors.

Thanks,
Brett

"Dave Peterson" wrote in message
...
For me, as long as I know that the original .xls workbook won't be
overwritten
(marked as ReadOnly in windows explorer???), I don't see any significant
difference between a .xlt template workbook and a .xls workbook.



Brett Romero wrote:

What is the difference in creating a spreadsheet vs. a template for
something, then later using that same spread sheet with different numbers
and saving it under a different name? How is a template more beneficial
here?

Thanks,
Brett


--

Dave Peterson



  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Why create a template?

There's no magic bullet. You have to make the changes in both workbooks.

You may be able to create a macro that you could use to make the changes to the
older workbooks.

Brett Romero wrote:

Let's say I'm working with two spreadsheets. One of them I keep updating
and improving. How do I implement these changes into the older spreadsheet?
If basically the same format except now I have cells turning different
colors based on conditionals, I'm checking for division by zero, I've
formatted cell length and width and changes text colors.

Thanks,
Brett

"Dave Peterson" wrote in message
...
For me, as long as I know that the original .xls workbook won't be
overwritten
(marked as ReadOnly in windows explorer???), I don't see any significant
difference between a .xlt template workbook and a .xls workbook.



Brett Romero wrote:

What is the difference in creating a spreadsheet vs. a template for
something, then later using that same spread sheet with different numbers
and saving it under a different name? How is a template more beneficial
here?

Thanks,
Brett


--

Dave Peterson


--

Dave Peterson
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 apply template in excel ? or can I create a autoformat in e Udayraj Dhulekar Excel Worksheet Functions 0 October 6th 05 06:22 AM
How do I create a form template that will be sequential numbered Gilly Excel Discussion (Misc queries) 1 September 13th 05 10:37 PM
The Template Wizard retains the original location for my database Packwood Excel Discussion (Misc queries) 0 April 15th 05 05:25 PM
how do I change an excel template into a "workbook" joyce Excel Discussion (Misc queries) 5 April 14th 05 04:38 PM
How do I create a template in Excel? Struggling Person01 New Users to Excel 3 January 9th 05 09:09 AM


All times are GMT +1. The time now is 01:56 PM.

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

About Us

"It's about Microsoft Excel"