Updating links
 

Hi,

I have exchange rate of several currencies in a workbook that is updated on
a monthly basis. From this, all the rates will be linked to several other
workbooks (more than 20). The problem is when I emailed out those workbooks,
all information, formulas and charts are affected as the recipents do not
have the master exchange rate workbook. Is there a solution to this? If not,
I will have to stick to the old way of copy and paste.

Thanks