thanks

in excel for pivot button, you can change datasource via a button?

for word, is there any button/command for this? like change link for mail merge? i am trying to avoid renameing filename to achieve that. :O

i did what you said but when i save/close the word doc, and reopen it, it is still pointing to a.xls despite i have changed it to b.xls.