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