It will disappear if your query is wrong which is the most likely explanation here.
I would recommend using tables and not searching entire sheets. You can create tables in your excel file.
The query you were writing is essentially, Select ALL from Entire Excel Sheet.
It would look something like SELECT * FROM [TABLE NAME HERE]
Although I recommend being more precise as that doesn't really gain you anything since you can just select a table inside datalinq anyway.
A full query would look something like;
SELECT [COLUMN NAME HERE] FROM [TABLE NAME HERE] WHERE [COLUMN YOU WANT TO CHECK NAME HERE] = Value you want to check here.
An example would be;
SELECT [FIRST_NAME] FROM [HOME_ROSTER] WHERE [NUM] = %Jersey%
That would get you the first name from the home roster table where the number colomn equaled the value in the datalinqkey value.
It's in % here because its a datalinq key but you could just as easy write 11 eg;
SELECT [SECOND NAME] FROM [FOOTBALL TABLE] WHERE [JERSEY] = 11
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------