Lo All ... o/

Nearing home time to EVE ONLINE! \o/

However, I have been Googling how to do this and not finding the solution I am looking for.
  • I have one workbook that is pulling data from other workbooks
  • Main Report is on a Company Server
  • Other Workbooks also on Company Server
  • Currently ALL docs need to be opened to update the correct data
  • I want the doc to update no matter who has opened the file and
  • Update regardless of whether or not the other workbooks are or aren't open.

Thanks fellas!