update data in excel object

[slamdunk]

Hi,

I've a word document with excel object. The cell b1 is set to import data from a text file. How can I get this cell to import data automatically when the word document opens without any user interaction?

Thanks!

[Tinbendr]

If you pasted the object as a link, it should auto-update.