Saving the spreadsheet every few seconds or so could be done with a
timer I suppose but it sounds like I've been looking at a bad solution
in attempting direct linking. Would DDE server be an option?

Thanks,

Joe