Data base function

  • Thread starter Thread starter Partly Void
  • Start date Start date
P

Partly Void

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/ExcelSelectCaseDfunctions.htm


Regards,
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DGET function can't update unless linked file is open 1
Link To File That No Longer Exists 1
DGET Function + External data from another excel file 2
Using cell reference with logical operator in DGET expression 1
DGet vs VLookup 3
Use Index to get range 4
dget function 2
Question using DGET function 1

Back
Top