Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data range
Hi
I have a workbook with an external data range. It refreshes correctly from the data source, however when I hide the workbook (using Windows|Hide) it stops refreshing. Is there a way to hide a workbook and still refresh it? The only solution I have (as of yet untested) is to create a macro that will unhide the workbook long enough for the refresh to occur and then hide it again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External data range | Excel Discussion (Misc queries) | |||
external data range a two way street? | Excel Discussion (Misc queries) | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
How can I check if data in an external data range is changed afte. | Excel Worksheet Functions | |||
How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) |