Spreadsheet File B references by name a cell value in Spreadsheet File A.
When File A is opened, the references in B convert from the range name to
the cell location (i.e from "Value" to B2) and stay that way even when File
A is closed. How do I maintain range name references when the referenced
file is opened?