Hi,

I have a chart which looks for data from a table which is dynamic.
Earlier, I was using it perfectly but recently I used
Application.calculation=XLManual in one of the macros of the sheet and
even though I turn it back to automatic, something is messed up. The
tools, options, calculation shows manual and the chart just doesnt
update - no matter what happens in the table. When I try to change
chart type, then only it takes the new data...

Can someone tell me some codes which i can insert in my macro when I
look up for chart so that it gives the latest chart

Thanks,
Anshuman

what is the code for turning it back to automatic
could the macro be exiting before using this section of code

"anshu" wrote:

Hi,

I have a chart which looks for data from a table which is dynamic.
Earlier, I was using it perfectly but recently I used
Application.calculation=XLManual in one of the macros of the sheet and
even though I turn it back to automatic, something is messed up. The
tools, options, calculation shows manual and the chart just doesnt
update - no matter what happens in the table. When I try to change
chart type, then only it takes the new data...

Can someone tell me some codes which i can insert in my macro when I
look up for chart so that it gives the latest chart

Thanks,
Anshuman

tools, options, calculation shows manual...

Didn't you just answer the question?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"anshu" wrote in message
ups.com...
Hi,

I have a chart which looks for data from a table which is dynamic.
Earlier, I was using it perfectly but recently I used
Application.calculation=XLManual in one of the macros of the sheet and
even though I turn it back to automatic, something is messed up. The
tools, options, calculation shows manual and the chart just doesnt
update - no matter what happens in the table. When I try to change
chart type, then only it takes the new data...

Can someone tell me some codes which i can insert in my macro when I
look up for chart so that it gives the latest chart

Thanks,
Anshuman