It looks like it is missing the worksheet name, something like:
DGET ('c:\tmp\[tmp_excel.xls]Sheet1'!A1:D20;"ID";A1:A2)
If the sheet is not called Sheet1, change as required

Hope this helps,
Miguel.

"Nader" wrote:

Hello,

I'm trying to use the function DGET and get data from another excel
worksheets and it doesn't seems to work.

Does this looks correct : DGET ('c:\tmp\[tmp_excel.xls]'!A1:D20;"ID";A1:A2)
?

thanks in advance !

Nader