automatic date in chart

In January, Jon Peltier replied to a question of inserting a date in a chart
that would dynamically change.

"select the title, type = in the formula bar, then click on the
cell. This works with chart titles, axis titles, data labels, and shapes
(text boxes etc)."

It worked perfectly for me, however, there seems to be a continuous
iteration of the formula. When I click on any of the charts I have added
this to, the calculation seems to begin and it (along with the hourglass)
continuously blinks. I click off the chart and it ceases. Any ideas why?

Thanks,
casey

For all who will come up with an answer to this, I may have solved my
problem. There are several thousand links to another excel database. If
that is not opened while I'm making changes then apparently this phenomena
occurs. By keeping the "linked" excel open it does not occur.

tia anyway,
casey

"casey" wrote:

In January, Jon Peltier replied to a question of inserting a date in a chart
that would dynamically change.

"select the title, type = in the formula bar, then click on the
cell. This works with chart titles, axis titles, data labels, and shapes
(text boxes etc)."

It worked perfectly for me, however, there seems to be a continuous
iteration of the formula. When I click on any of the charts I have added
this to, the calculation seems to begin and it (along with the hourglass)
continuously blinks. I click off the chart and it ceases. Any ideas why?

Thanks,
casey