Using the DGET function in an excel spreadsheet that has a link to another
workbook
the cell shows an error value unless the source file is open. Using update
in edit links also shows an error. When the source file is open it works 100.

Using Windows XP and Office 2003