Editing an Excel table in a Word document Solved

Question

Hello,  I'm explaining my problem:  I have an Excel table in my Word document. I would like to add a row to this table. The problem is that no matter what I do, when I try to modify this table, it automatically opens Excel (when I want to stay in Word). I've tried double-clicking, right-clicking on the table -> object worksheet -> edit, but nothing works... And as a result, when I add a row in Excel, the number of rows in my table in Word remains the same as before, so the last row gets truncated...  I think this might be due to a Word setting like "automatically open worksheets in Excel," but I can't find how to resolve this issue...  Thank you in advance,  Maxime

boba_fett_nr · Accepted Answer

Thank you, Raymond, for your response, but I think you misunderstood the question.  To explain step by step what I'm doing:  Blank Word365 file Insert a table in Excel spreadsheet format A table with 7 columns and 10 rows appears on the Word sheet. The Excel application launches simultaneously. I can only fill in those 7 columns and 10 rows. Any additional row is truncated. In the Word file, changes to this table are treated like an image file because I can stretch or shrink it as well as crop it, but I cannot add rows or columns.  Previously, with earlier versions of Word, by double-clicking on this same table, the column names and row numbers would appear on the same file (Excel was not launched), allowing me to add and delete rows or columns and modify everything. For example, when inserting a row, the last row was not truncated.  What surprises me is that a friend who has the same version of Word and Excel as me, on the same file, can perform the operation I used to do before.  It’s certainly a matter of Word or Excel settings, but I can't see where to make the change.

Mike-31 · Answer

Hello,  Right-click in the left margin of the table next to where you want to insert one or more rows/Insert/and in the floating menu choose Insert rows above or below  See you! Mike-31  I am responsible for what I say, not for what you understand...

Mike-31 · Answer

Hi,  these are two different issues. If you're on Word, I gave you the instructions to follow, and if part of your table is disappearing, it's likely that it exceeds your page. However, if you add a row to your table in Excel, it's normal that Word doesn't take it into account; you need to replace it in Word.  -- Catch you later Mike-31  I am responsible for what I say, not for what you understand...

Raymond PENTIER · Answer

Hello Maxime.  There is a small confusion in your analysis: Initially you explained "when I try to modify this table, it automatically opens Excel (while I want to remain in Word)"; and now you add "if I double-click on my table, it directly opens an Excel page, it doesn't open the table in Word". An Excel spreadsheet inserted into a Word document is not the same as a Word table! In the latter, you can intervene directly. But in the former, you can't write or modify anything directly; you need to double-click to access the Excel software. And once you have added your row, you increase the height of the Excel window before clicking in the Word area. Nothing simpler... -- Retirement is nice! Especially in the Antilles... Raymond (INSA, AFPA)

boba_fett_nr · Answer

Hello, I have the same problem as you. With the older versions of Office, by double-clicking on an Excel table inserted in Word, it was possible to adjust the width of columns, the height of rows, and to add or delete rows or columns. Everything was done in Word. Since moving to Office 360, when I double-click on my Excel files, the Excel application launches, I can modify whatever I want, but the layout in Word remains fixed. If my initial table has 5 rows and I want to add one, the 6th row will not be visible in Word. I have a friend who also switched to Office 360 and she doesn't have this problem; everything works like before. Unfortunately, she doesn't know what she clicked on to achieve that. Have you found a solution to your problem, and could you share it with me? Thank you.

m@rina · Answer

Hello,  I am very surprised that you can use the Crop function, which is dedicated to images. Indeed, if you can "crop," it means that the table has become an image. But in that case, it is no longer editable in Excel.  You can only "crop" an Excel table when it is pasted as a linked image. But if you used the Insert Excel Table function, it is not a link but an embedding... So for me, it's not clear.  Is it possible to see a document with an embedded Excel table as you usually do? You can upload it here: https://www.cjoint.com/ and don’t forget to provide the link.  m@rina  -- There is no need to ask me your questions privately. I do not respond to them.

m@rina · Answer

Hello,  Your table is indeed an embedding (EMBED). As for the cropping, yes I understand. It's indeed called "cropping," but it's not really because it simply allows you to reduce the table...  So, normally when you choose Open, you open the file in Excel, but when you choose Edit, you stay in Word. I understand that it doesn't work that way for you. I therefore recommend trying a repair of Word because there are no specific options to adjust.  That said, personally I never use the Insert Excel table function. I prefer to create the table, then copy and paste it into Word as an Excel sheet. The result is the same but it's more convenient. Try doing it that way. Do you have the same problem?  While waiting for a better solution: Open your table in Excel, modify it, copy the entire table, do not close Excel, and paste it into Word as an Excel worksheet (special paste). Then delete the first table. It may not be ideal, but it works as a temporary fix.  m@rina  -- There's no need to ask me your questions in private. I won't respond.

Befa0909 · Answer

Hello,  I just had the same problem this morning. Just copy the object and paste it into Excel. Make the changes, update the object, and paste it back into your Word document in the same place. From there, it will remain editable from Word. This involves modifying your templates.

Editing an Excel table in a Word document

8 answers

Quotes and electronic invoicing

User folder disappeared in c:

Whatsapp photos disappeared despite delete box not checked

Yahoo mail inbox blocked

My computer stays connected for very little time

Firefox 152 and cookies

Unable to connect with my pc

Unable to enter your new visa card on facebook

Connect a dvd player to a windows 10 pc

Tele techwood twk3916fhd12b