Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an Excel document in which I want to add another Excel document.

I hoped it would be possible in the same manner how we used to embed a Word document in another, using the Insert → Object option. But this doesn't seem to work with Excel.

Is there any solution to this?

share|improve this question
    
This very comprehensive website may help you youtube.com/user/ExcelIsFun –  Simon Dec 11 '12 at 13:28
1  
@Simon Could you please explain how? All I see is a YouTube channel with thousands of videos on it. –  slhck Dec 11 '12 at 13:30
    
I was recommending Sandeep to look on there, he may find the answer. If I knew how I would have definitely have posted the answer. Its a very good site (one of the best infact) to learn about excel –  Simon Dec 11 '12 at 13:33

1 Answer 1

up vote 4 down vote accepted

I'm not sure what issues you are having, but my copies of Excel 2007 and 2010 both allow you to insert another Excel sheet as an object.

  1. To do it, you need to click on the Insert tab in the ribbon, and then click Object. This will open a dialog window allowing you to set the object to insert.
  2. Click on the Create from file tab to insert your specific file.
  3. Click Browse button and select the file you are looking to insert.
  4. There are a few check-boxes for options. Link to file will put a reference to the file,
    so any edits made to the embedded workbook will be reflected on the original.
  5. Display as icon will show an Excel icon with the name and location of the original file.
    Leaving this unchecked will embed the sheet itself within a floating, moveable and sizable window.

enter image description here

share|improve this answer
    
Thanks! All this time, I was playing around the "Create New" tab. Didn't even bother to check out the "Create from file" tab as you said. Silly me... –  Sandeep Dec 18 '12 at 10:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.