Worksheet/workbook events not being triggered

F

fromeo

Hi,

I have an Excel 2003 spreadsheet pulling in data from a SQL Server
database and populating a sheet (called "Data"). I also have a pivot
table in a sheet (called "Pivot"). I want to be able to refresh the
pivot table when the data import is complete (it takes some time). To
work out which event to use as the basis for my refresh code, I have
added a MsgBox call to the following events in the "Data" worksheet:

Private Sub Worksheet_Activate()
Private Sub Worksheet_Calculate()
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Private Sub Worksheet_Deactivate()
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

And the following events in the WorkBook:

Private Sub Workbook_Activate()
Private Sub Workbook_PivotTableOpenConnection(ByVal Target As
PivotTable)
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)

But none of the events are being triggered at any point when the data
is imported into the "Data" worksheet. Is this normal? Or am I missing
something?

Many thanks.
 

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

Top