Hi VBA Experts,'
I have this simple VBA to refresh a single Pivot Table in a file, but it doesn't work.
This is a small part of many steps in my process. The PVT Data doesn't refresh and thus, this throws out the other steps.
Sub Workbook_RefreshAll()
Sheets("PVT").Activate
ActiveSheet.Range("C6").Select
ActiveWorkbook.RefreshAll
End Sub
Can someone say why this wouldn't work?
Imran
I have this simple VBA to refresh a single Pivot Table in a file, but it doesn't work.
This is a small part of many steps in my process. The PVT Data doesn't refresh and thus, this throws out the other steps.
Sub Workbook_RefreshAll()
Sheets("PVT").Activate
ActiveSheet.Range("C6").Select
ActiveWorkbook.RefreshAll
End Sub
Can someone say why this wouldn't work?
Imran