Embedded workbooks

exex-Large

New Member
Joined
Nov 8, 2005
Messages
2
I have 4 workbooks named the following: -

Parts.xls
Model.xls
Warranty.xls
Report.xls

Is there a way to embed the first 3 workbooks into the Report.xls workbook? so that I have 1 workbook and so that I can run formulas on the Parts.xls, Models.xls and Warranty.xls. :)

If I can embedd the first three books into the Report.xls book, what would the formula statement look like, would it be similar to what I currently do:

(example) =IF('u:\excel\[Parts.xls]Service'!$A$2:$A$1000=B2,1,0)
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
1. Why embed? If you want to combine the sheets, just copy all the sheets into the one file.

2. If you don't want to combine, there is still no need to embed, you can write formulas that reference external Excel files.

To see how referencing external files works, do this:
(To make conceptualization easy, lets say we are working with report.xls and parts.xls
1. Open both workbooks.
2. In report.xls type an equals sign ("=") to start a formula
3. Choose the parts.xls and select a cell or range of cells.
4. Press Enter
5. Look at the formula Excel created. That will show you the syntax you need.

3. You cannot reference embedded spreadsheets.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,001
Messages
5,834,820
Members
430,324
Latest member
bosphoruskid

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top