Thanks Dave, I'm sure I have tried that (our server's path is the R:
\drive) but it did not work - the next time I opened the workbook the
reference to the .xla was lost. I'm at a conference for a few days so
I will try it again when I get back and report back.