B
Bodo
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.
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.