Take a look at the data tools "Consolidate." It was made specifically for
this purpose.
KC

"Nadine" wrote:

I have 16 workbooks, each containing a summary worksheet of stats, the
summary sheets has a table of 34 columns with 13 rows of stat data in each
cell
Each summary links into a master summary workbook.
In the master workbook, I have a copy of each summary worksheet from the 16
workbooks, using the = function to link the summary sheets cells from each
workbook to fill the values
The the master summary sheet obtains it's numbers from the 16 worksheets in
the master workbook.
The workbooks stored on a network shared drive
Before up upgrading to office 2007/vista, the master workbook would take a
few minutes to open. Now that I have converted the workbooks into excel
2007, the master can take up to 10 minutes to open, yes our network is a bit
slow, waiting for that to get upgraded.

But wandering if there is a better way for me to link these workbooks so it
may not take as long to open.