#### kcdill

##### Board Regular
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.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
kcdill said:
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.

Copy --> Paste Special .. Paste Links.

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?

Replies
11
Views
844
Replies
9
Views
448
Replies
1
Views
722
Replies
4
Views
307
Replies
3
Views
271

1,221,418
Messages
6,159,793
Members
451,589
Latest member
Harold14

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back