| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh all in Excel
You could easily record a macro to do both for you. This should help:
http://vbaexpress.com/kb/getarticle.php?kb_id=80 **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Texas Tonie" wrote in message ... When I use 'refresh all' on the External Data toolbar, it only refreshes the external data page, and not the adjoining pivot table. I need to click 'refresh' on the pivot toolbar as well in order for the pivot to display the new information. How can I get around this two-step? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
| How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
| Excel Seems to Refresh every 5 seconds | Excel Discussion (Misc queries) | |||
| Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
| Refresh Excel file | Excel Discussion (Misc queries) | |||
![Anne Troy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
