Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh order when refreshing all in a workbook
I created a workbook with two sheets. In sheet1 there is a table connecting
to an external data source (From Sql Server). Sheet2 has a pivot table of which ithe data are bases on the table of sheet1. Now when I click the refresh all button to refresh all objects in the workbook, the order is refresh pivot table first, and then the table of external data. So we have to refresh all again or refresh the pivot table individually. Is this a bug? Can we manually change the refresh order to refresh external data first, then the pivot table based on it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing Workbook Connections with Access | Excel Discussion (Misc queries) | |||
Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
Refreshing Pivot Tables in a Shared Workbook | Excel Worksheet Functions | |||
Why are the cells of my workbook not refreshing? | Excel Worksheet Functions | |||
Can you reformat order of items in Pivot Tables after refresh? | Excel Discussion (Misc queries) |