Shane,
I'm using Excel 2003 SP3.
I created the text box by selecting it from the drawing toolbar, then
mousing it on the chart. I then clicked the in formula bar, typed the = sign
and then selected the tab with the data source, clicked in the cell, and hit
enter. I've re-created several ones and even a control label box all with
the same result. it works well until I re-open the file, then it no longer
updates.

The file does have external data links, which I select the "Do not update"
upon opening. Not sure if this impacts the operation of the text box (which
is not linked to the external data). It is odd, I have other excel files
with this function (albeit the text box is on the same sheet as the data
source) and it still functions.

Thanks for the help.
-Bruce


"Shane Devenshire" wrote:

Hi,

I can't duplicate your problem. What version of Excel are you using? What
does the formula look like on the formula bar? How did you create the text
box?
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"brumanchu" wrote:

Hello,
I have a dynamic chart on it's own tab with a scroll bar to select the
number of weeks in view at any given time. I added a text box that
references the cell link for the scroll bar to display the value of the
scroll bar (corresponds to the week number). The link works great as long as
I'm in the file. When I close it and re-open, the text box no longer updates
and the formula is not present in the bar.

Can anyone advise what may be happening?

Thanks in advance for your help.
-Bruce