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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh Pivot Chart with Table? 0
Selecting Date Range in a Pivot using VBA 0
How do i export a pivot chart as a static chart object? 2
Arrange columns (lo - hi) in a Pivot Chart bar graph. 2
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Changing/Manipulating Legend range for a Pivot Chart in XL2010 vsXL2003 and below. 0
Error in date format of first Pivot table chart 0
Change source data in a pivot chart 4

Top