excel on multiple computers
 

i have Register.xls on three computers "Front Left, Front Right, and Back"
i also have Data.xls and Tables.xls that are located on the "Back" computer.
all three registers have equations that read off Data.xls and Tables.xls

example:
=count([data.xls]register!a1:a10000)+count([Tables.xls]new!a1:a1000)

the problem is i copy and pasted the version of Register.xls from the back
computer that is on the same computer as Data.xls and tables.xls to the
computers that read off Data.xls and Tables.xls from the back computer.
so now all the equations on the front computers read

=count('\\BACKRIGHTCOMP\Choice\[Data.xls]Register'!a1:a1000)+count('\\BACKRIGHTCOMP\Choice\[Tables.xls]new'!a1:a1000)

and with the equations like this, they dont update automatically

thanks in advance