Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - Linking workbooks
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - Linking workbooks
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
An error msg in Excel 2007 regarding Linking but no linking in fil | Excel Discussion (Misc queries) | |||
Linking workbooks in Excel | Excel Discussion (Misc queries) | |||
Linking excel workbooks | Excel Discussion (Misc queries) | |||
Linking workbooks in Excel | New Users to Excel | |||
linking excel workbooks | Excel Worksheet Functions |