I have a reports workbook that is linked to a summary workbook which in turn
collects information from 15 other individual workbooks.
When I open up the reports workbook, it updates itself from the summary
workbook but the summary workbook does not update itself at the same time (is
this correct?). Is there a way I can force a total update programmatically so
that the reports contain current information.