I have lot of charts (44 in total) in one sheet. The data for the charts are
linked to another spreadsheet. When I update the values the charts are not
updated even though both files are open at the same time. It will only update
if I manually re-visit the data ranges or close the file and re-open it. Is
there are any why to telling (using macros) to update all the charts in the
workbook?

Thanks in advance
Seng