nayannilank
06-17-2009, 12:08 AM
Hi All,
I have a workbook consisting of 10 worksheets. First three worksheets contains Pivot Table, which gets the data from 4th, 5th and 6th worksheets. 4th, 5th and 6th worksheets gets the data (using a web query) from an external CSV file. I want to have a "Refresh Data" on the fist sheet, which is when clicked, refreshes the external data and the pivot tables in the following sequence :-
Refresh the data on 4th Sheet.
Refresh the data on 5th Sheet.
Refresh the data on 6th Sheet.
Refresh the Pivot Tables on 1st sheet.
Refresh the Pivot Tables on 2nd sheet.
Refresh the Pivot Tables on 3rd sheet.
I used "ThisWorkbook.RefreshAll", but it refreshes the data in one go, not in the required sequence. I also tried "Sheets(index).Calculate" for different sheets, but it does not refreshes the external data.
Any help in writing the macro/subroutine to achieve this functionality would be highly appreciated.
Thanks,
Nayan
I have a workbook consisting of 10 worksheets. First three worksheets contains Pivot Table, which gets the data from 4th, 5th and 6th worksheets. 4th, 5th and 6th worksheets gets the data (using a web query) from an external CSV file. I want to have a "Refresh Data" on the fist sheet, which is when clicked, refreshes the external data and the pivot tables in the following sequence :-
Refresh the data on 4th Sheet.
Refresh the data on 5th Sheet.
Refresh the data on 6th Sheet.
Refresh the Pivot Tables on 1st sheet.
Refresh the Pivot Tables on 2nd sheet.
Refresh the Pivot Tables on 3rd sheet.
I used "ThisWorkbook.RefreshAll", but it refreshes the data in one go, not in the required sequence. I also tried "Sheets(index).Calculate" for different sheets, but it does not refreshes the external data.
Any help in writing the macro/subroutine to achieve this functionality would be highly appreciated.
Thanks,
Nayan