Embedding EXcel file(with multiple sheets) to excel file
- Thread starter kissha
- Start date
Kissha
I'm not sure about your use of some words like embed.
In Excel you can move or copy worksheets from 1 file to another, doing so then leaves the new copy in the new file. They are part opf the new file and will go with in where ever you send it.
You can alos link to external files using a number of methods being either formula directly referencing the external files or data connections to the external file using ODBC, SQL etc. Both of these methods fail when you send files to other people as it is possible that the links will not be establ;ished when they recieve them.
In the first case where you have copied and pasted sheets from 1 file to another, they can, if already linked to other data in the source file, establish formula links to the now external sheets if all the sheets aren't transfered together.
Having as you say a Homeppage style overview can easily be done and Chandoo has many tutorials and classes on just this.
It is best done when all the data resides within 1 workbook.
I'm not sure about your use of some words like embed.
In Excel you can move or copy worksheets from 1 file to another, doing so then leaves the new copy in the new file. They are part opf the new file and will go with in where ever you send it.
You can alos link to external files using a number of methods being either formula directly referencing the external files or data connections to the external file using ODBC, SQL etc. Both of these methods fail when you send files to other people as it is possible that the links will not be establ;ished when they recieve them.
In the first case where you have copied and pasted sheets from 1 file to another, they can, if already linked to other data in the source file, establish formula links to the now external sheets if all the sheets aren't transfered together.
Having as you say a Homeppage style overview can easily be done and Chandoo has many tutorials and classes on just this.
It is best done when all the data resides within 1 workbook.