We have built a summary workbook which depends heavly on Excel's ability to
read data from named cells in dozens of other workbooks. The VBA code looks
similar to this:

C.Range(FreeCFYieldCol & R).Formula = "='w:\" & Wb &
".xls'!iFCFYLD"


The problem is performance. Each workbook has maybe a dozen named cells
which are to be read by the summary workbook. These workbooks sit on a
network. I'm assuming that each workbook file is opened and closed every
time a named cell's value is read.

Question, is there a method my which we can code the summary workbook so
that it retrieves the values of all 12 named cells (probably storing those
values in variables) so that the workbooks are opened and closed but once?

TIA