after adding data, grafics not calculated until save and reload

J

jbz

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
 

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

Similar Threads

Need VBA Help...adding and deleting 40 sheets 1
HELP ListBox Save Data to Hidden Sheet, and ReLoad It upon opening 2
strange behaviour 1
Macro to Break Links Before Saving Sheet 4
Tasks Changing Levels After Save 1
Working with moving dynamic ranges 1
Problem in the data of the file in the FTP after the saving of excelsheets 10
Using Sheets.Add after and want to keep a sheet as the first sheet 2

Top