I know how to copy data from one Excel file and do a Paste Special, Paste as
Link onto another file. That works fine but the updated data flows in one
way only. Is there a way of linking two Excel files so that you have the
same data on each one, but they are linked so that updating data in one file
will automatically be shown in the second file, and this will happen no
matter which of the files is updated? I don't see anything in Excel that
would allow this.