Hi Ian,
quoting the manual:
Remote references
.................
You may also reference constants, fields and ranges from a different
table, either in the current file or even in a different file. The
syntax is
remote(NAME-OR-ID,REF)
where NAME can be the name of a table in the current file as set by
a `#+NAME: Name' line before the table. It can also be the ID of an
entry, even in a different file, and the reference then refers to
the first table in that entry. REF is an absolute field or range
reference as described above for example `@3$3' or `$somename',
valid in the referenced table.
For remote references in other files, you need to use entry IDs,
not tables names. At least this is how I understand it.
HTH,
--
Bastien
