senators40
Technical User
Hi,
I have a chart that has 12 columns. When I copy it in Excel and Paste Special and select Microsoft Excel Worksheet Object. It pastes into the worksheet.
I want to edit some of the information inside the workbook in Word so I double click on it.
When that happens I can edit it but when it goes back to the regular word document several columns are missing.
I found out through "Dreamboat" (AKA Anna Troy) that you right click on it, goto worksheet object and then edit, the columns will stay as entered.
Is there any way to make double clicking on the spreadsheet within the document default to edit or to disable the open feature and put up a message that tells them to use the edit feature.
Thanks,
Jeff
I have a chart that has 12 columns. When I copy it in Excel and Paste Special and select Microsoft Excel Worksheet Object. It pastes into the worksheet.
I want to edit some of the information inside the workbook in Word so I double click on it.
When that happens I can edit it but when it goes back to the regular word document several columns are missing.
I found out through "Dreamboat" (AKA Anna Troy) that you right click on it, goto worksheet object and then edit, the columns will stay as entered.
Is there any way to make double clicking on the spreadsheet within the document default to edit or to disable the open feature and put up a message that tells them to use the edit feature.
Thanks,
Jeff
