Updating Links with AutoFit Row Formatting
 

I have a master workbook that gets all its information from other multiple
workbooks. One of the worksheets within the master workbook gathers all
employee performance discussions from the other workbooks. Those multiple
workbooks are formatted for Row AutoFit and works perfectly. However, when I
open my master, it asks me to update the links, which I really need to do for
all the other data, but when I do, the worksheet with all the discussions in
it does not flow over to show all the text. I have figured out that if I have
the other workbooks OPEN when I update my master, the discussions flow over
to the master perfectly. How can I make this happen without having all the
other workbooks open?

Thank you!