Embedded Excel Table in Word doesn't display correctly (Word for Windows)

Question

We run Microsoft Office 365. We have several users with Microsoft word documents with embedded excel spreadsheet/tables in them. The Spreadsheets work fine. The word document works fine. The issue is when they click out of the excel object, the column/row information and other excel features (sideways and vertical scroll bars) stay visible and block view of the surrounding word document. So if there is text just below the object, it will be blocked. When you view the print preview, everything looks correct. The only thing visible about the object is the table/its information. You can reset the view, by going to view>web layout>print layout. Doing this will change to the web layout and then back to the print layout and it will reset the excel object so it looks like it should. Below are screenshots:

This is the normal view. The word document has text above, below, and far below the excel table/object. The Excel object/table has text and formulas that all work in it. When you click in to edit, and then click out, this is what happens to the word document:

The border and excel column/row information, sheet number, and scroll bars stay visible, even when you are out of the excel object. You can see it is blocking test under the excel object/table. This happens every time you click out of the object. A workaround that we have found is to reset the view by going to view > web layout > then go back to print layout. This will make it go back to showing correct as the first image.

Has anyone else had this issue? Is there a permanent fix besides the workaround that we have found?

Answer 1

Hi Tina,

Thanks for sharing these detailed information with us. We deeply understand this issue has affected your daily work. Very sorry for the inconvenience caused.

We have tested from our side and found we can reproduce the same issue in different channels of Word. (Current channel, current channel Preview).

We recommend you feedback for this problem via File>Feedback or from Help menu>Feedback within Word. Feedback submit by this way directly goes to the related team. This is the best way to let the developers aware of this issue, The more reports they received from customers, the more likely they will be able to find something affected customers in common, work on the issue and help to investigate it and fix it soon.

Currently, as OP Zeke mentioned, you may try to reset the view by going to View tab>Web Layout>then go back to Print layout.

Doing this will change to the web layout and then back to the print layout and it will reset the Excel object so it looks like it should. When we test from our side, this way works.

Edited:

We found 3 workarounds shared from customers. You may try each of the workaround. At the same time please also feedback within Word application.

In addition, we'd like to make a summary for this issue so that other community members can easily find the related information:

Issue description:

===============

If you insert Excel tables to Word document from Insert>Table>Excel Spreadsheet, or by copying cell range from Excel and paste it in Word via Paste Special>Microsoft Excel Worksheet Object

when you clicking in the embedded table and then click out of it, it still displays the table with border and sheet number, and it blocks the view of the surrounding text.

Environment:

===============

Word desktop application

Current channel version 2202(Build 14931.20120)

Current channel (preview) version 2002(14931.20132)

Current status:

===============

Please send feedback for this issue via File>Feedback or from Help menu>Feedback within Word application.

Workaround:

===============

Workaround 1: Reset the view by going to View tab>Web Layout>then go back to Print layout.

Workaround 2: Right-click the Excel object, open up "Worksheet Object" and use Open. It will open the object in a new window and closing it will update the worksheet.

Workaround 3: Go to View > New Window to open a 2nd window for the problem document, then close the original window. New window shows the embedded Excel object properly.

We appreciate your patience and understanding.

Best regards,

Tina

[Updated by Tina Chen MSFT on 4:30 PM, Tuesday, March 15, 2021(UTC)]

Answer 2

I'm not able to reproduce that behavior in Word from Microsoft 365 for Enterprise, Version 2201 (Build 14827.20198) Current Channel, 64-bit, on Windows 10. What version/build/product of Office and version of Windows are you using? From the scroll bars in your screen shots, it appears that you may be on Windows 11, or at least in the "new experience" UI selected in the Coming Soon pane in Word.

If you aren't on the latest build for your channel as listed at https://docs.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date you should update to it. Also, if you're using 32-bit Office, replace it with the 64-bit version, https://docs.microsoft.com/en-us/DeployOffice/change-bitness because we've noticed several bugs in the 32-bit version that aren't present in 64-bit.

Answer 3

Hi Zeke,

Thank you for querying in this forum.

We went through the post carefully and understand the situation is that when you click an embedded Excel table in Word document to edit it, it blocks view of the surrounding content. We do understand it has affected your daily work. Sorry for the inconvenience caused.

Thanks for sharing the workaround for this issue.

For troubleshooting and just to make sure we test by using the same steps and same environment as yours, we'd like to confirm the following information. Appreciate your understanding that sometimes the initial reply may not resolve the problem very soon. However, we can work together to narrow down the situation.

1.How do you embed the Excel table object into Word? By select the range of cells from Excel, then go to a Word document, in Home tab, click Paste>Paste Special>choose "Microsoft Excel worksheet Object"? Or do you use the steps Paste>Link & Keep Source Formatting?

2.What is the version of your Windows OS?

3.What is your Office apps version? Please go to File>Account, capture a screenshot of Product Information, as shown below.

Many thanks for your patience and effort. Hope you are keeping safe and well.

Best regards,

Tina

Answer 4

We are experiencing the exact same problem.

Please let us know when a true fix is available