Excel/Refreshing Pivot Table
I am trying to refresh all the pivot tables in my workbook through workbook open event and worksheet open event. But its shwoing some error. Pls look into this and help.
Here is the file -
Use this for your workbook_open event code:
Private Sub Workbook_Open()
Dim pt As PivotTable
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
For Each pt In sh.PivotTables
Refreshall also refreshes querytables and that appears to be where you are having your problem. This will just refresh all pivottables.
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here