One thing is not the other but embedding a spreadsheet in a document is done all the time. But once in a while a new user will want a single file which is not supported.
Bob
how to combine word and excel into one document
![]() | Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years. Thanks, CNET Support |
how to combine word and excel into one document
Discussion is locked
One thing is not the other but embedding a spreadsheet in a document is done all the time. But once in a while a new user will want a single file which is not supported.
Bob
Use Insert Object and choose Microsoft Word or Excel to insert an already prepared file or a new file. Save the combined document in the program you're working in. The embedded file will remain in your saved file.
I wonder if that will do what they want.
In the setup I have I want the spreadsheet to be "live" in the word document. But that's not the same thing.
Bob
After Insert Object, the spreadsheet is live, click to the side of the spreadsheet to close the active area. You can then format if you want the spreadsheet centered in your document by selecting and right clicking for your menu. It looks better if the spreadsheet is centered. If you need to work on the sheet "live", double click the sheet at any time and work away.
And got a file in the .DOC. Yes it worked as I could double click and get the spreadsheet.
I wonder if it matters which version of Office is in use?
Bob
PS. Actually I don't wonder. Just asking in a way to elicit more information.
I've been embedding spreadsheets since the late 1980's. It doesn't matter which version you're using. Try it.
Tried it. Failed. Thought the version may matter. Works on Windows 7 and Office 2003. Seems Microsoft has a way with bugs.
Bob
What versions of Word and Excel are you using? Which OS? I was not using MS Office applications when I was working in the DOS environment. I was using WordPerfect and their spreadsheet program. I could do it with their programs way back then.