Hi. I have this code entered for one of my charts:

Private Sub Chart_Activate()

'update pivot table when chart becomes active
UpdatePivotTables

Module1.UpdateDataLabels

End Sub

This works fine. It executes everytime I click the chart's tab.

The problem I'm having is that if this chart is current when I first
open the workbook, the code does not run until I leave the chart then
click back to it.

How can I get the chart updated if it is current when I open the
workbook?

Thanks!

Ken