excel 2007 trendline equation

[Erwin_Goethals]

I'm used to see t trendline updating automatically when the source data change.
Now this does not work any more.
In the Q&A I read bout dynamic charts what does that mean ?

 

[ShaneDevenshire]

Hi Erwin,

I can't duplicate your problem. If my data changes the associated trendline
changes. Are you adding the trendline via the Chart Tools, Layout command?
Is Recalculation set to Automatic?

 

[Erwin_Goethals]

Hello,

Taking a working worksheet from my computer running excel 2003 and opening
it on my excel 2007 , I notice the trendline equation is not updated any more.
I have to delete the trendline and make a new one in order to get a correct
equation.
The way I add a trendline is by selecting the basic graph and select add
trendline.
My worksheets are standard in automatic recalculation, so still no solution.
If needed I can sent the two versions.
Thanks.

 

[ShaneDevenshire]

Sorry to take so long to get back to you but I missed your response.

I've tested importing 2003 charts with trendlines into 2007 and have not
duplicated the problem.

You can send me copies of the two files at (e-mail address removed)