after adding data, grafics not calculated until save and reload

I have a speadsheet ~52MB used for 42MB without problems
in which I select y a list and with Vlookup analyse a subset to produce
grafics of the data
I have added some data ( of last year ) on one sheet of that
now the grafic sheets wil not be recalculated until I save and reload the
whole sheet

I tried already:
coppy the project
coppy all sheets to a new project
make a new grafic ( out of 30 grafic)
reset fonts on the grafic sheets
renewed title e.g.
delete the added data

of course I can start all over but that meens a 14 day job
and no guaranty that is will help

does some one know how to analyse this problem to know what is causing this
or a work around

thanks