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

From Excel's help menu:
If no record matches the criteria, DGET returns the #VALUE! error value.
If more than one record matches the criteria, DGET returns the #NUM! error
value.
You can use any range for the criteria argument, as long as it includes at
least one column label and at least one cell below the column label for
specifying the condition.

Here is some more information:
http://www.ozgrid.com/News/ExcelSele...Dfunctions.htm


Regards,
Ryan---

--
RyGuy


"Partly Void" wrote:

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