Network users somehow opening write copy of .xltm template

[bindibadgi]

Hi

I have created a template document in Excel 2010 (saved as .xltm format) and saved it on a network drive. It is essentially a questionnaire which many users need to be working on at once. There is no need for data to be saved in the document (it saves the answers to the questions in a separate Access database), so I assumed that the .xltm format would work for me.

The problem arises only every few days, where I find that somebody has a write+read copy of the file open, and it prevents me from rolling out an updated version of the template. It doesn't prevent me, or others, from opening the file and using it, but I just can't delete it, rename it, replace it, etc.

I always thought that an .xltm document should only open as a read only copy, and that it would not affect the version saved on the network drive. Normally, this seems to be the case, since lots of people across the country can have my document open at once, and it never has any issues.

I don't know if it has any bearing on it or not, but I've disabled saving of the document by way of a Workbook_BeforeSave subroutine which contains the following:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

    If ActiveWorkbook.ReadOnly Or Not Right(ThisWorkbook.Name, 4) = "xlsm" Then 'a local copy doesn't seem to report an extension at all
        Cancel = True
        If SaveAsUI Then SaveAsUI = False
        Saved = True
    End If

End Sub

My company's IT help desk has essentially thrown up their hands at this one, so it appears I'm on my own until I can come up with an explanation or solution for them. Is someone able to help me with an explatnation of what I'm doing wrong here, or how I can avoid this?

Thanks for any insight

Stanton