Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to apply template in excel ? or can I create a autoformat in e | Excel Worksheet Functions | |||
How do I create a form template that will be sequential numbered | Excel Discussion (Misc queries) | |||
The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) | |||
how do I change an excel template into a "workbook" | Excel Discussion (Misc queries) | |||
How do I create a template in Excel? | New Users to Excel |