Linking Workbooks

[kcdill]

My cost estimating workbook consists of 5 worksheets (steel plate, pipe fittings, structurals etc.) containing lists of material. Each worksheet uses different formulas (lookup, IndexMatch, etc.) that call up values (unit weight, density etc.) found listed on the TablesSheet. My cost estimating workbook is currently about 1.3 megs and growing. About one half of the file size is attributable to the Table Sheet. We create several hundred cost estimates every year and I am using too much storage space. I want to reduce the estimating workbook file size by moving the TableSheet to a new TablesWorkbook. The new TablesWorkbook would be stored on the same server as the cost estimating workbook.
Question: How do I link all the different formulas in my estimating workbook to the new TablesWorkbook? Do I have to append each formula on by one? There must be a better way. Thanks in advance for your help.

 

[Brian from Maui]

My cost estimating workbook consists of 5 worksheets (steel plate, pipe fittings, structurals etc.) containing lists of material. Each worksheet uses different formulas (lookup, IndexMatch, etc.) that call up values (unit weight, density etc.) found listed on the TablesSheet. My cost estimating workbook is currently about 1.3 megs and growing. About one half of the file size is attributable to the Table Sheet. We create several hundred cost estimates every year and I am using too much storage space. I want to reduce the estimating workbook file size by moving the TableSheet to a new TablesWorkbook. The new TablesWorkbook would be stored on the same server as the cost estimating workbook.
Question: How do I link all the different formulas in my estimating workbook to the new TablesWorkbook? Do I have to append each formula on by one? There must be a better way. Thanks in advance for your help.

I maybe wrong here, but if the worksheets are presently in the same workbook, use Edit/Move or Copy Sheet to a new workbook and Excel should change the formulas to reflect the new workbook. Test this first. I've done this a few times and Excel always recognizes the different workbook.

 

[Zack Barresse]

Copy --> Paste Special .. Paste Links.

 

[kcdill]

Linked Workbooks Except Combo Boxes

Thanks in advance for the help. I moved my TablesSheet to a new workbook. Excel took care of the links like you said. However the one remaining problem is with all the ComboBoxes. The ListFillRange for each ComboBox is on the TablesSheet in the new WorkBook. Now the ComboBox drop down menus are blank. Is there a way to link the ComboBox on the Estimate Workbook to the ListFillRange in the Tables WorkBook?