Best answer for why to use a template (xltx) rather than normal file (xlsx).
Hello!
I'm getting wrapped around this and it's not coming to me:
"Templates are good files to preserve the desired structure for future workbooks."
I can do that with it saved as xlsx.
"You can lock the cells"
You can do that with xlsx.
"When you open it, you can save it as another workbook."
I can do that with xlsx.
What am I missing? What can I do with a template that I can't do with a normal file?
I appreciate your help and info!
Regards,
leaning
Hmmm...Well, there you go.
Template files are meant to be saved as read only; the design/layout and formulas protected with passwords; thus modifications are not allowed, except by the owner.
They force renaming as an xlsx on save and cannot be accidentally overwritten/deleted.
When you open the template, the data entry cells are always empty. If you reuse an xlsx file, the data cells contain the previously entered data that must be deleted, etc.
Last edited by protonLeah; 08-11-2018 at 05:31 PM.
Ben Van Johnson
Yeah, I like that answer a whole lot better, especially about the empty cells on open. Now, I have to create a few templates just to see that. Thanks!!
Although I am trying it (New workbook. 1 in A1, 2 in B1, =Sum(a1,B1) in C1, and if I leave the 1 and 2 and save as .xslx or xltx, they come back as 1 and 2. If I delete the 1 and 2 and save them as .xlsx and .xlt, they both come back as empty. No difference there. If I protect everything but A1 and B1, same action.)
Can you show me how to demonstrate the correct behavior?
Regards,
leaning
When you open a template file, what's in there is exactly what was stored when it was saved. If you want the data entry cells blank, make them blank and save the template. Excel has no idea what cells are data entry.
The primary difference between a template file and an xlsb/m/x file is that the default action is New rather than Open, so it requires a deliberate act to overwrite the template.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks