can't add a new sheet from template / how to edit a template

Hello

I know, that's really two questions, but they relate to each other, so I put them into one thread:

1
I created a one-sheet template, and a new workbook from that sheet. When in that new workbook I go Insert>Sheet>Other and select the aforementioned one-sheet template, Excel crashes, or if not, it adds the new sheet, but then no longer saves the workbook and starts producing error messages (like: "An unexpected error has ocurred. AutoRecover has been disabled for this session of Excel.").
1a
Now, the complication is that this is working when I do a model operation with a generic template sheet. So I checked the template that I actually want to form sheets after, and Excel finds no errors, nor does it's name contain any unusual characters. What could Excel prevent from working with a template like this?

2
How do I edit a template? The only way I can find is to manually find the spot in finder, open, and save with the same name. But: if I do that, the documents basing on that template don't change accordingly. If they're intended not to, the whole template procedure makes no sense. I could then just as well copy a file. — I've been searching for tutorials on that, but google doesn't even return a single result on Excel "edit template". Therefor my very basic question here.

Since I need to have various workbooks with a different combination of a limited range of sheets, this is somewhat bothersome, and I'd greatly appreciate any help on this.

(I maybe should add that all of this refers to Excel:Mac 2008, running on a PPC.)

How do I edit a template? The only way I can find is to manually find the spot in finder, open, and save with the same name. But: if I do that, the documents basing on that template don't change accordingly.

Creating a sheet from a template creates a copy of the template, without any links to the original. If it did otherwise, it would be a disaster.

... you need to change, say, the VAT from 16 to 19% ...

Put a formula in the template that refers to another workbook that contains the relevant values.

... or add one field somewhere, and you don't want to do that like 32 times manually?

You can do it in code (because you can do most anything in code), but changing the template will have no effect. See prior post.

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes