I have some problems with chart updating in excel. I have two
identical charts in two different sheets(in a large workbook with
about 40 sheets). Those charts get their data from the same sheet. One
from the column F and the other from column G. The problem is that I
have done some additional programming and now one of the charts in not
updating. The right range is there, the data is there, but there is
nothing in the chart! Same story with the other chart except that here
everything goes fine. If I hit Shift+F9 to recalculate nothing
happens. I have also tried application.volitile in the code,
ctrl+shift+F9, but it all just won't help! I have googled a bit and it
seems that Excel sometimes has "recalculation" problems but I haven't
found any solutions for this. Any suggestions?

If you have User Defined functions in a worksheet (and it sounds like you
do), then if one of them causes an error, that can stop calculation. That
might be part of your problem.

--
Regards,
Tom Ogilvy

"Nick" wrote in message
om...
I have some problems with chart updating in excel. I have two
identical charts in two different sheets(in a large workbook with
about 40 sheets). Those charts get their data from the same sheet. One
from the column F and the other from column G. The problem is that I
have done some additional programming and now one of the charts in not
updating. The right range is there, the data is there, but there is
nothing in the chart! Same story with the other chart except that here
everything goes fine. If I hit Shift+F9 to recalculate nothing
happens. I have also tried application.volitile in the code,
ctrl+shift+F9, but it all just won't help! I have googled a bit and it
seems that Excel sometimes has "recalculation" problems but I haven't
found any solutions for this. Any suggestions?

Check the contents of the source data range. If you've turned the values
into text through your other programming, you may lose sight of the
points in the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Nick wrote:

I have some problems with chart updating in excel. I have two
identical charts in two different sheets(in a large workbook with
about 40 sheets). Those charts get their data from the same sheet. One
from the column F and the other from column G. The problem is that I
have done some additional programming and now one of the charts in not
updating. The right range is there, the data is there, but there is
nothing in the chart! Same story with the other chart except that here
everything goes fine. If I hit Shift+F9 to recalculate nothing
happens. I have also tried application.volitile in the code,
ctrl+shift+F9, but it all just won't help! I have googled a bit and it
seems that Excel sometimes has "recalculation" problems but I haven't
found any solutions for this. Any suggestions?