| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic refresh of external data
I have 2 data pages in my workbook, that are each connected to an external
data source, with 2 pivot tables, one connected to each data page. For a complete refresh, I need to hit 'refresh all' twice. What can I do to make it work for one 'refresh all'. Suggestions welcome... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic refresh of external data
You can change the "refresh" properties on the underlying data query by
selecting data range properties on the query. A simple right click while highlighting a cell in the output will get you into the properties screen. "Texas Tonie" wrote: I have 2 data pages in my workbook, that are each connected to an external data source, with 2 pivot tables, one connected to each data page. For a complete refresh, I need to hit 'refresh all' twice. What can I do to make it work for one 'refresh all'. Suggestions welcome... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lost ability to refresh external data | 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 | |||
| Prompting to allow External Query Data Refresh | Excel Discussion (Misc queries) | |||
Linear Mode
