Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
jbz
 
Posts: n/a
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"