Query is lost when Excel s/sheet opens
 

I have a Excel spreadsheet set up with five tabs. Four of the tabs have
queries where I refresh them to pick up information from a third party
database. The last tab has lookups/formulas which pulls the info from the
four tabs into tables for me. I sometimes lose the query in the first tab
when I open the spreadsheet. It just disappears and I have to reset it up.
What is causing this? How can I stop it from happening? Using Excel 2002 (in
office XP).
I am assuming (after having had this problem for a while and trying to fix it)
- Excel thinks there is an error and it automatically "fixes" it?
- Only happens when I open the file (not while file is in use, saved or
closing)
- File is used off the network drive. Now moved to my C drive to see if it a
network problem, and waiting to see if this helps.
Does anyone have any suggestions or comments?

--
dlb - Planner