Quote:
Originally Posted by Marcia
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.
|
My vba code is opening all the files in read only mode upon opening. Feel free to use it, just copy the middle contents for each workbook and put it inside Workbook () that you can choose in VBA on the left.