How to Edit an Embedded Excel Spreadsheet Directly Inside a Word Document
Question details
The user wants to edit an embedded Excel spreadsheet directly within a Word document (in-place editing) rather than having it open in a separate spreadsheet application window.
- Product
- Word
- Device & OS
- not provided
- Scenario
- Editing an Excel workbook embedded as an object within a Word document.
- Observed behavior
- The embedded Excel spreadsheet opens in a separate Excel window instead of allowing in-place editing directly on the Word document canvas.
Ensure that you have a compatible spreadsheet application installed on your computer, as embedded objects rely on the spreadsheet program to render the in-place editing interface.
Insert the Excel Object Without Linking or Displaying as an Icon
To edit the spreadsheet directly inside the Word document, you must embed the file correctly by ensuring both the link and icon options are cleared during insertion.
When an object is inserted as a link or displayed as an icon, double-clicking it triggers the system to launch the default external application. By embedding the file directly, you allow Word to load the spreadsheet editing tools in place.
Navigate to the 'Insert' tab on your Word document ribbon, click on the 'Object' button, and select 'Object...' from the dropdown menu.
In the Object dialog box, click on the 'Create from File' tab and use the 'Browse' button to locate your Excel workbook.
Before inserting, verify that both the 'Link to file' and 'Display as icon' checkboxes are unchecked. Click 'OK' to embed the file.
Double-click the newly embedded Excel object in your Word document. The spreadsheet will now open for in-place editing directly within the document.
Embed and Edit Spreadsheets Easily with WPS Office
WPS Office provides seamless integration between its Writer and Spreadsheet applications, allowing you to easily insert, view, and edit tabular data directly within your text documents without dealing with external application windows.
- 1. Open WPS Writer: Launch WPS Office and open your text document using the WPS Writer application.
- 2. Insert the Spreadsheet Object: Navigate to the 'Insert' tab, click the 'Object' icon, and select 'Create from file'.
- 3. Embed the File Correctly: Select your spreadsheet file, ensure that 'Link to file' and 'Display as icon' are both left unchecked, and click 'OK'.
- 4. Edit Directly on the Canvas: Double-click the inserted spreadsheet object. The WPS Spreadsheet tools will load right inside your document canvas for quick and easy editing.
Frequently Asked Questions
Why does my embedded Excel file open in a separate window?
If the 'Display as icon' or 'Link to file' options were checked when you inserted the object, double-clicking it will prompt the file to open in a separate standalone Excel window instead of allowing in-place editing.
Can I change an existing linked Excel object to an embedded one?
You cannot directly convert a linked object into an embedded object that supports in-place editing. You will need to delete the existing linked object and re-insert the Excel file using 'Insert > Object' while keeping the link option unchecked.
What happens if I edit a linked Excel file inside Word?
If the file is inserted with 'Link to file' checked, any edits you make will modify the original external Excel file. However, embedded files (where the link option is unchecked) are stored entirely inside the Word document, so your edits will not alter the original source file.
How do I exit in-place editing mode for an embedded Excel spreadsheet?
To stop editing the embedded spreadsheet and return to the standard document editing mode, simply click your mouse cursor anywhere outside the boundary of the Excel object on your page.
