Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data refresh
Upon hitting 'refresh all', my data page refreshes all-right, but my
connected pivot table does not. If I hit 'refresh all' again, it does. Is there a way that I can refresh the data page, and have it also refresh the pivot table in a single go? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data refresh
Hi,
No. Connected Excel sheet have different Data column. Therefore, depending upon the number of excel sheet you have incorporated in your Excel sheet, you have to refresh those number of times. Because they are different data source definition. Challa Prabhu "Texas Tonie" wrote: Upon hitting 'refresh all', my data page refreshes all-right, but my connected pivot table does not. If I hit 'refresh all' again, it does. Is there a way that I can refresh the data page, and have it also refresh the pivot table in a single go? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic refresh of external data | Excel Discussion (Misc queries) | |||
external data refresh | Excel Discussion (Misc queries) | |||
External Data Refresh not working | Excel Discussion (Misc queries) | |||
refresh external data on a protected sheet | Excel Discussion (Misc queries) | |||
Automatic refresh of external data | Links and Linking in Excel |