Auto generating work order number

I was shocked to see when I opened the template one day that the number had increased by 10. Is their opening the *.xls file on their system also increasing the number?

Yes.

Keep the process manual to eliminate your headaches. May not be as elegant but its functional.