I had a bunch of charts updating nicely from a scroll bar in Excel 2003 but
with the update to 2007, the formulas lose their connections e.g. series
value shows "=[0]!AllPerfRev". I can replace the [0] with the reference to
the correct Tab in my worksheet and everything works OK (it's a big job
replacing them all though!) but this gets lost when I exit everything (saving
as I go of course) and come back in. Bingo - all these links have
disappeared.

Anybody have any ideas?

I have a sheet that explains how the whole thing worked in Excel 2003 if
that's any help.