password to modify for template does not work

[owendodd]

Hi iwas wondering if anyone would know a reason for this problem.

I cannot seem to be able to password to modify an excel template. When i create a template save it and click on general options before saving, enter in a password to modify and click ok and save the template.

Then when i go into the template no pop-up appears asking me to enter a password. any ideas?