How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask WesPCDr Your Own Question
WesPCDr
WesPCDr, Information Systems Manager
Category: Microsoft Office
Satisfied Customers: 1507
Experience:  Microsoft Office Specialist
21171802
Type Your Microsoft Office Question Here...
WesPCDr is online now
A new question is answered every 9 seconds

Hi I have a word document (Word 2010). I have inserted

Customer Question

Hi

I have a word document (Word 2010).
I have inserted an excel table ('Insert -> Table -> ExcelSpreadsheet' or 'Copy' from Excel -> in word 'Paste Special -> Excel Worksheet Object'

-> field shows as { EMBED "Excel.Sheet.12" }, that I can edit, etc.



I save the word file.

After reopening I cannot edit the embedded object anymore!


Only solution ?? found so far:
Convert embedded objects to either 'Binary' or 'MacroEnabled Worksheet'.
=> worked after save and reopen


QUESTIONS:
1. Is this work-around fool prove (i.e. does it work for any configuration of Win 2010)
2. Is this documented in MS Knowledge Base?
3. Is a bugfix expected, so that normal Menu operations provides working results?
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  WesPCDr replied 5 years ago.

WesPCDr :

Hi, I can help answer your question.

WesPCDr :

Try dragging the Excel file into your Word document.

Customer :

Thanks. So what else do you need to know?

WesPCDr :

This will link the document to the Excel file and capture changes.

Customer :

Wait, I'll try.

WesPCDr :

ok

Customer :

What I thought: Same as Insert-> XL-Table or copy/paste: creates Normal Excel.sheet.12 , which does not open after save!

WesPCDr :

  1. Open both the Word document and the Excel worksheet that contains the data that you want to create a linked object or embedded object from.

  2. Switch to Excel, and then select the entire worksheet, a range of cells, or the chart that you want.

  3. Press CTRL+C.

  4. Switch to the Word document, and then click where you want the information to appear.

  5. On the Home tab, in the Clipboard group, click the arrow under Paste, and then click Paste Special.


 



  1. In the As list, select Microsoft Office Excel object.

  2. Click Paste link to insert a link to the object.

Customer :

see my initial message: this is the copy/past variant.

Customer :

it does not work: Object is not saved!

Customer :

I still have to convert the object so pasted into 'Binary' -> so I'd like to have an answer to my 2 questions

Customer :

sorry ists 3 questions

WesPCDr :

I'll open the question so other experts can help.

Expert:  Danielle-Mod replied 5 years ago.

Hi, I’m a moderator for this topic and I wonder whether you’re still waiting for an answer. If you are, please let me know and I will do my best to find another Expert to assist you right away. If not, feel free to let me know and I will cancel this question for you. Thank you!

Related Microsoft Office Questions