title: How to link many excel files to one master file, so that if I update the single master file, all linked files also update?
body: <p>I'm wondering if anybody can help?</p>
  
  <p>I have a large number of excel files. These are commission statements and some are converted from USD to UK Sterling, from UK sterling to Euros etc etc. </p>
  
  <p>They are quarterly statemnets and at present I have to go through each file one by one and enter in the specific currency conversion rates for that month. </p>
  
  <p>I was thinking it would be great if I could link all these statements to a single excel file which contained the conversion rates. I could then update this single currency conversion file and all the other files would update.</p>
  
  <p>I think I could manage this, but there is a little problem I have ran into.</p>
  
  <p>If I then send the statement files out to individuals, the local link between the two files would be lost and therefore, surly so would the conversion figures. The only fix I can see would be to send the file containing the conversion rates along with the statement, but if possible I would prefer not to do this.</p>
  
  <p>I hope you can understand my problem and it would be great if anybody could suggest any fixes to this!</p>
  
  <p>Thanks in advance :o)</p>
  
  <p>I have had some advice here about including a hidden rates sheet in all excel files: </p>
  
  <p><a href="https://stackoverflow.com/questions/5274831/linking-cells-from-2-different-excel-files-but-then-keeping-figures-if-emailing">Linking cells from 2 different excel files, but then keeping figures if emailing only one file?</a></p>
  
  <p>The rates within the visible sheets could then be linked to the cells in the hidden rates sheet and then the hidden rates sheet could be linked to a seperate single master rates file, which I would alter to update rates on all linked excel files. </p>
  
  <p>I' still a bit unsure on how this would work if I was to send a single excel file to people in an email, because the local link to the master rates file would be lost. Is there a work arround? </p>
  
  <p>Any help would be really really appreciated! </p>