Hi,

At work I use a spreadsheet template (*.xltm). I have always used this, but now when I try to save instead of defaulting to a Macro-Enabled Worksheet it goes to overwrite the template I am using. This was not happening before and I haven't changed any formatting.

When I check my excel options the default save file is macro-enabled workbook - as it has always been.

Also, now when I open the template it opens a new window for excel, preventing me from copying over worksheets, I hope this makes sense.

My colleagues all use the template and I have checked the properties of their shortcuts and mine is the same - yet it doesn't open up as a template on their computers.

Just wondering if there is a quick fix as it's is becoming increasingly annoying! Hope this makes sense...