wes i have tried that before. linking to excelsheet with a query, but i
have never succeded to "read" from the same workbook, only reading in
closed workbooks.

tell me how did you do to set a query to the same workbook.

/jocke


--
jocke
------------------------------------------------------------------------
jocke's Profile: http://www.excelforum.com/member.php...nfo&userid=766
View this thread: http://www.excelforum.com/showthread...hreadid=488758

First, set up your data tables and assigned range names to them.
Save the workbook before you try to set up the query against it.
(You don't need to close the workbook)
Set up the query in the current workbook referenceing the tables in
the same workbook. Note: You will need to point to the network location
of the saved file, but Excel will use the data in the open version.

That's about it.

Does that help?
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=488758