| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Pivot tables refresh
I have a few database queries in a spreadsheet, each query is then
referenced by it's own pivot table. I then have a VBA button on the main "Report" page that when pressed refreshes all "ThisworkBook.RefreshAll". Problem is that I have to press is more than once. I'm guessing it has something to do with the order in which I added the queries and pivot tables, but is there a way to have the VBA code refresh all correctly. I have tried putting the code in twice but it runs the second line before the first one has completed all the queries/tables. Dean -- http://www.dkso.co.uk/ http://homepage.ntlworld.com/dkso |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| Pivot Tables | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
