External data query not being saved
 

Hi:
I have an Excel 2003 worksheet set up with an external data query to pull
data in from a SQL Server 2000 db. The query works fine. Its properties are
set to save the password.
However, I notice that rather *randomly*, Excel decides not to save the
query. I am forced to re-enter the query but what's worse is that I loose the
formating and a bunch of calculations (formulas) that I have based on the
returned data.
Any help would be greatly appreciated.
Thank you!