title: Excel macro: other user wants to get latest content of open workbook
body: <p>I have a (possibly very silly) question about Excel macros but I can't seem to find an answer anywhere else. My problem is this:
  I have an Excel file open all day and I updated it throughout the day when needed.
  My boss has another Excel file with a macro. Whenever he runs that macro, he is supposed to get the latest information from my file into his spreadsheet. What he actually gets though is the information from the last point I saved my file. So, even though I've set autosave to run every minute, if I last saved my file 2hrs ago, my boss will see my contents as off 2hrs ago and not anything else I've done since then.
  Is there anyway to bypass this without the macro closing/saving/interfering with my file at all?</p>
  
  <p>I appreciate your help!</p>