Ok, I know there's several macro's close to what I need, but not sure of how
to tweak them to get exactly what I want...
I have 3 workbook types. #1 is a source only (12 workbooks), #2 (also 12
workbooks) pulls from #1 and from #3, #3 (one workbook) pulls from #2.
If #2 isn't opened after entry to #1, #3 doesn't show the current data.
I need a macro that will prompt to run on opening #3 to Open #2.
I'd like it to open them into the background and on closing #3, save the
current data.
Will opening 12 workbooks simultaneously and also updating links to 12 more
workbooks take forever?
Is there a better way to keep the data in workbook 2 current without opening
it?