Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change order of query updates
I have a workbook that has a query from an SQL database on one sheet and
several pivot tables on subsequent sheets that analyse the output of the original query. The problem I have is that if I use the 'Update All' button, it refreshes the data source after the pivot tables - so I have to press it again to get the pivot tables to reflect new changes in the data. Each refresh takes quite a while to carry out, so it's annoying having to do it twice when the underlying data has only changed once. If I could change the order so that the data was refreshed before the pivot tables, it would remove this problem. Can anyone help? When I first put the workbook together it actually refreshed the data first (by accident, not design), which was great. However I've had to rebuild it and since then it has the problem described above. Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change order of query updates
You might consider running your Queries from macros within Excel. That way
you can control what happens to whom and when......... hth Vaya con Dios, Chuck, CABGx3 "ste1000" wrote: I have a workbook that has a query from an SQL database on one sheet and several pivot tables on subsequent sheets that analyse the output of the original query. The problem I have is that if I use the 'Update All' button, it refreshes the data source after the pivot tables - so I have to press it again to get the pivot tables to reflect new changes in the data. Each refresh takes quite a while to carry out, so it's annoying having to do it twice when the underlying data has only changed once. If I could change the order so that the data was refreshed before the pivot tables, it would remove this problem. Can anyone help? When I first put the workbook together it actually refreshed the data first (by accident, not design), which was great. However I've had to rebuild it and since then it has the problem described above. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the order of item in a legend for a chart? | Charts and Charting in Excel | |||
How to change an existing query | Excel Discussion (Misc queries) | |||
How do I change order of rows in pivot table? | Excel Discussion (Misc queries) | |||
HOW DO I CHANGE THE ORDER OF THE SHEETS IN EXCEL WORKBOOK? | New Users to Excel | |||
How do I change the order of choices in menu File- Send To | Excel Worksheet Functions |