Creating a pivot chart in vba?

S

Simon Lloyd

All, i know nothing about creating Pivot tables and charts, i've onl
just bothered to start using them. I now have a need to produce pivo
charts and suceeded in doing that, my question is how do i refresh th
data automatically or should i rebuild the pivot each time using VBA. I
automatic refreshing is a simple option i'd go with that but the shee
the table and chart are on will be protected

All advice welcome

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 
L

Luke M

Right click on your PivotTable, Table options. You should see an otpion to
refresh table automatically on opening of workbook. Or, if you've building an
Event macro, or just want to do some programming and then refresh your
PivotTables, you can use the following code:

ThisWorkbook.RefreshAll
 
Top