I have a workbook that is linked to several other files through calculations and Index-matches, and it won't automatically update them unless the other files are open (the update mode is set to automatic). In fact, it gives me an error for cells that are linked to one of the sheet if I calculate the sheet without having the linked file open. The files are all very complex so I need them to be kept in manual mode, so that might be causing the issue, but is there some setting or workaround I am overlooking that could fix this? Or will I need to create a macro to open and update everything. Thanks!