Does anyone know a workaround for the problem of a structured reference to an external data table returning '#REF', when the source file is closed?
Other than a) open the source file or b) replace with standard (relative or absolute) references.
A Microsoft article on the problem can be found here.
Bookmarks