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)
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,436
Messages
5,572,099
Members
412,441
Latest member
kelethymos
Top