I have 2 files, File2 gets data from File1. I used a formula in file2
=X:\Folder\[File1.xls]Totals'!$D$2. If both files are open on the same
computer, File2 updates automatically when data in File1 is changed. If I
open File2 on another computer I get a window that asks to "Update File". I
click OK and the file opens with the correct information, however it doesn't
update if data on File1 is changed after File2 is open.

Is there a way to have File2 update automatically when File1 is changed?

Thanks for your help.
Doug