Hi - I have a highly customised xl report system which up till
yesterday was perfectly stable.

There are various option/radio buttons across the top to allow the
user to select volume/spend etc, drop downs to allow for different
filters etc.

The main part of the report is a grid which is populated using VB (it
populates another sheet with vlookup formulae and then the actual
report grid cells access the vlookup cells using offsets - needs to be
like this as there is a hidden columns issue).

Then there are 2 charts below the grid showing the colum and row data
which change when user clicks on a grid cell - all worked fine till
yesteday. I think the difference was that I changed the right charts
cell refs to be on another sheet.

When user clicks on one of the radio buttons the system freezes. If I
take the right hand chart out all seems fine.

When I come to put the chart back in the chartnumber of the next cell
seems to be somewhat greater than what is was previously. Am I correct
in thinking that every new chart gets the next number along. If so
it's as though a load of new charts have been created. Same has
occurred with various buttons and the radio buttons.

I am using XL 2003 on Windows XP prof. My employers don't want me to
download the office update for all sorts of reasons.

Any ideas?

Thanks

Andrew