Hello, I need help. I created a excel workbook with two sheets. Sheet 1
(AssessmentChart) contains a Pivot chart. Sheet 2 conatins a detail report
(DetailReport) with autofilter on. Workbook saved using Excel 97 - 2003
compatability format. Data from connection to SQL Server. I have users of
Excel 2003 & 2007. I'm using Chart events to allow me to click on bars in
chart to make detail report active and filter it based on the bar that is
clicked. This work perfectly for my Excel 2007 users. When my users of
Excel 2003 click on a bar they get a Run time Error 9 on the following
statement in vba code.

ActiveSheet.ListObjects("Table_CRPRDNMSQXXX_Mytabl e_DB001_data_vwDetailRptData").Range. _
AutoFilter Field:=29, Criteria1:=strHoldPassWatchFail

strHoldPassWatchFail (data series ) is a global variable that I use to
filter the data in my detail report.
Table_CRPRDNMSQXXX_Mytable_DB001_data_vwDetailRptD ata is SQL server data
source for detail report. Please help not sure what is going on, why my
Excel 2003 users are getting error.



--
DC