I use many external database queries in my worksheets. To refresh results, I
simply right click in the data and select Refresh. Sometimes, however, after
the refresh, I right click again and find that the query definition has
disappeared, meaning the worksheet thinks I've returned text only and there
is no option to refresh any longer.

I keep archives of my queries so I can copy/paste back my original query.
But this is a major pain.

I can't find anything in the Microsoft knowledgebase on this. Any ideas?