Worksheet Object

Embedded Worksheet

menus and toolbars change to excel
SS - without link
(Edit > Links) is disabled

Linked Worksheet

Select cells, copy
(Edit > Paste Special) Microsoft Office Excel Worksheet Object
with an option of paste link

SS - with link

If link is "automatic" and Excel workbook is open any changes in Excel are immediately reflected in Word.

Links Dialog

SS links dialog box after inserting this type of link

Shortcut Menu


Update Link - Refreshes the link (no prompt) - same as (Edit > Update Link)

(also appears bottom of Edit drop-down)
Edit Link - Opens up the workbook ready for editing. Excel must already be open.
Open Link - same as "Edit Link"
Convert - Displays the "Convert" dialog box. There are no conversion options for an Excel Worksheet. Displaying as an icon doesn't do anything ?
Links - same as (Edit > Links)

Inserting an Entire Workbook

(Insert > Object) Create from file
browse to workbook
only one worksheet is displayed, to display a different worksheet, double click and change the worksheet

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext