this is not a solution but an interest in this thread. My experience with formulae that are linked with other workbooks is that errors or #VALUE appear when the source workbooks are not open. I'll keep track on this so I could copy the correct vba code to open all linked workbooks instead of manually opening them.