Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External data refresh | Excel Discussion (Misc queries) | |||
External Data Refresh on save problem | Excel Discussion (Misc queries) | |||
external data refresh | Excel Discussion (Misc queries) | |||
External Data Refresh not working | Excel Discussion (Misc queries) | |||
Automatic refresh of external data | Links and Linking in Excel |