Although my workbook has the automatic calculation turned on , for some
reason when i update the range of the chart with new values it does not
update the chart untill i save , close , and reopen. Can anyone help ?


Z