I tried the hard coded network drive located rather than %username% also.
This made no difference to the behavour on my system.

I may just have to email the file company wide and have everyone manually
import it.

Thanks for your help.

John.