Yes,

It looks like this:

=Output!$AW$26:$AX$26


Before I start recreating this file from scratch which would be weeks
worth of work, are you sure this is a corrupted file issue?
Is there really no other way to force the charts to update? They
update if you close and open the workbook, so is there some way to
simulate that?

Peter


--
pwermuth
------------------------------------------------------------------------
pwermuth's Profile: http://www.excelforum.com/member.php...o&userid=24997
View this thread: http://www.excelforum.com/showthread...hreadid=385248