Thanks for your response Tom.
However, i don't believe this is the problem because every single chart
in the workbook is unresponsive to any change in the underlying data.
It is only happening in this workbook.
When i run a copy of the same workbook it's fine. In a new instance of
Excel it's also fine.
It has to be something to do with this workbook that seems to be turning
off the Charts.
I'm at a loss and getting to desparation stage.

Regards,
Ric


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!