Hi,
I have created an Excel sheet with a hyperlink in it that, when clicked, opens up a word document that is setup with a label mail merge, which is linked directly back to the same excel file and imports all of the data from it's list. I have been doing this for years with no problem but all of a sudden, when I click the hyperlink the mail merge only imports the data from the last time the Excel sheet was saved, not what is currently in the workbook. If I then save the excel file and click the hyperlink once again, the updated information appears on the mail merge word document. It used to pull up the most current data from the Excel sheet, whether or not I had saved the excel sheet. I use the hyperlink frequently so it can be a little annoying to have to continously save the file. Does anybody know how to reverse this phenomenon?
Thanks in advance,
Chris
I have created an Excel sheet with a hyperlink in it that, when clicked, opens up a word document that is setup with a label mail merge, which is linked directly back to the same excel file and imports all of the data from it's list. I have been doing this for years with no problem but all of a sudden, when I click the hyperlink the mail merge only imports the data from the last time the Excel sheet was saved, not what is currently in the workbook. If I then save the excel file and click the hyperlink once again, the updated information appears on the mail merge word document. It used to pull up the most current data from the Excel sheet, whether or not I had saved the excel sheet. I use the hyperlink frequently so it can be a little annoying to have to continously save the file. Does anybody know how to reverse this phenomenon?
Thanks in advance,
Chris