Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Template functionality in Excel
I'm confused about templates in Excel. When I've used a template in Word, it
won't allow me to just hit "save." It forces me to Save As a word doc. I just tried this with my Excel template, but it doesn't work. Does this function differently than Word? |
#2
|
|||
|
|||
If you open a template and hit save it won't save over the original since it
adds a number to the file and defaulats to *.xls and not *.xlt You have to physically change the name, the extension and directory to write over the original and then you'll be warned as well. Regards, Peo Sjoblom "Abi" wrote: I'm confused about templates in Excel. When I've used a template in Word, it won't allow me to just hit "save." It forces me to Save As a word doc. I just tried this with my Excel template, but it doesn't work. Does this function differently than Word? |
#3
|
|||
|
|||
Any chance you opened up the template -- and not created a new workbook based on
the template? Check the title bar. If you see .XLT, then you're editing the real template--not a workbook based on that template. (File|new is one way to create a new workbook (or document) based on a template.) If you have a workbook that's never been saved, you'll see the SaveAs dialog (and that works the same way in MSWord). Abi wrote: I'm confused about templates in Excel. When I've used a template in Word, it won't allow me to just hit "save." It forces me to Save As a word doc. I just tried this with my Excel template, but it doesn't work. Does this function differently than Word? -- Dave Peterson |
#4
|
|||
|
|||
OHHHHH!!!! Okay - I had to wait a day and then the lightbulb came on! Thanks
for firing the brain cells. This is what being unemployed for six months gets me! "Dave Peterson" wrote: Any chance you opened up the template -- and not created a new workbook based on the template? Check the title bar. If you see .XLT, then you're editing the real template--not a workbook based on that template. (File|new is one way to create a new workbook (or document) based on a template.) If you have a workbook that's never been saved, you'll see the SaveAs dialog (and that works the same way in MSWord). Abi wrote: I'm confused about templates in Excel. When I've used a template in Word, it won't allow me to just hit "save." It forces me to Save As a word doc. I just tried this with my Excel template, but it doesn't work. Does this function differently than Word? -- Dave Peterson |
#5
|
|||
|
|||
Good luck on the job search (if there's a search going on).
Abi wrote: OHHHHH!!!! Okay - I had to wait a day and then the lightbulb came on! Thanks for firing the brain cells. This is what being unemployed for six months gets me! "Dave Peterson" wrote: Any chance you opened up the template -- and not created a new workbook based on the template? Check the title bar. If you see .XLT, then you're editing the real template--not a workbook based on that template. (File|new is one way to create a new workbook (or document) based on a template.) If you have a workbook that's never been saved, you'll see the SaveAs dialog (and that works the same way in MSWord). Abi wrote: I'm confused about templates in Excel. When I've used a template in Word, it won't allow me to just hit "save." It forces me to Save As a word doc. I just tried this with my Excel template, but it doesn't work. Does this function differently than Word? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Where is the Template Wizard with Data Tracking Excel 2003? | Excel Discussion (Misc queries) | |||
Adding a chart to a Word template linked to an Excel doc. | Excel Discussion (Misc queries) | |||
Excel 2003 Viewer: No more "Browse in same window" IE functionality? | Excel Discussion (Misc queries) | |||
Does the add in Template Wizard exist for Excel 2003 | Excel Discussion (Misc queries) |