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