Business Query for Excel('97)

Problem with the Business Query add-in for Excel ('97). Queries run ok for
a while then, for no apparent reason, some items on the ‘BusinessQuery’ menu
become unavailable (greyed out) or the Business Query menu itself is greyed
out. Obviously when the ‘Refresh Query/ies’ options become unavailable the
queries can no longer be updated.
Sometimes closing and opening the file fixes this but sometimes it doesn’t.
The problem has even occurred when Excel and BQ are the only apps running on
the PC so it doesn’t look like a memory issue.
If anyone has experienced anything similar or has any ideas, it would be
very much appreciated.
Many Thanks,
Ailie Forgie.

Bienxanh (BOB member since 2020-05-29)