Solved

Excel Spreadsheet in a Word 2016 document.

Posted on 2016-11-27
3
51 Views
Last Modified: 2016-11-28
I have used Excel Worksheets embeded in Word documents for years. With Word 2016, I am getting a weird view of the spreadsheet and am unable to work within the spreadsheet as I have in the past. I have attached screenshots to illustrate my issue.
Example.docx
0
Comment
Question by:ergenbgr
3 Comments
 
LVL 17

Assisted Solution

by:Karen Falandays
Karen Falandays earned 250 total points
ID: 41904127
HI ergenbgr,
Obviously that is not the expected behavior. Can you tell me more? Are you using O365? How did you do the insert? Have you checked for updates and/or done a repair?
kfalandays
0
 
LVL 6

Accepted Solution

by:
Mike in IT earned 250 total points
ID: 41904433
I've tried experimenting with Word to see if I could reproduce anything that looked like the screen shots you attached and could not do so. I am able to easily insert a table or excel spread sheet into the Word doc.

I'm not sure how you have been doing it up till now, but to insert a spread sheet (and even be able to create multiple sheets in the spread sheet) use the "Insert" tab and select "Excel Spreadsheet" from the drop down under "Table". This will insert a Spread sheet into the doc. the double clicking on it will allow you to edit it. I've added the file that you uploaded, but with a spread sheet added on the second page.
Example.docx
0
 

Author Comment

by:ergenbgr
ID: 41904562
Thank you both for your responses. My city office still uses Word 2007 so that is where I work most frequently. However at home I have Office 365.

Karen F.:  In Word 07 I click on INSERT\OBJECT\MicrosoftExcelSpreadsheet. Doing so embeds a spreadsheet into my Word doc. Do that in Office 365 and you get the results I showed in my screenshots.

Michael M: The method you demonstrated works. I was not aware that Microsoft changed the manner in which you embed spreadsheets.

Thank you for your assistance. My problem is resolved and I will award the points.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

912 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

20 Experts available now in Live!

Get 1:1 Help Now