Problem with Refresh all external data
 

Hi,
in my excel workbook I have several sheets with external data links.

When I open the excel file, I first deactivate automatic refresh of external
data, than enter a value into a cell which is the selection criteria for most
of the external data queries.

Then I click "Refresh All data" icon on the external data toolbar.
This works ok for most of the queries but there are some that won't refresh.
I don't get any error's while the refresh runs.

I'm clueless at the moment why this occurs.
I set the property of the queries so that the data gets refreshed
automatically whenever the related cell value changes.

Appreciate any thoughts on how to troubleshoot.

--
Thanks in advance
Bodo