How can I insert a fully functional Excel 2010 spreadhseet within a Word 2010 document?

Posted on 2011-10-03
Last Modified: 2012-05-12
How can I insert a fully functional Excel 2010 spreadsheet within a Word 2010 document that I can modify, edit, and add to directly while I am viewing the Word 2010 document?

I need to have actual Excel 2010 spreadsheets with data (contained in rows & columns) that I can actually add to or edit on the fly. Each of these Excel 2010 spreadsheets contained within the Word 2010 documents must be an actual separate Excel spreadsheet file that is embedded within the Word 2010 document.

I don't want to simply copy the Excel 2010 files and then paste them into the Word 2010 documents as file attachments; these Excel 2010 documents must be actual "living" Excel databases that I can modify within the Word 2010 document itself.

Please provide me with the exact steps as well as additional online documentation that explains how I can do this.
Question by:Knowledgeable
    LVL 89

    Accepted Solution

    Open the Excel Worksheet, copy the section you want, then in Word, Paste Special -> Spreadsheet Object.

    I keep my stuff in old format even though I use Office 2010, so ignore the 2003 reference. It all works.

    Caution: do not make the spreadsheet too large or it will bog down severely. .... Thinkpads_User
    LVL 89

    Expert Comment

    by:John Hurst
    Thank you. I was pleased to assist and good luck going forward. ... Thinkpads_User

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
    Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now