Display data from a workbook in a Notes view
Document On the Create menu, click a Lotus Notes form that includes an editable rich text field. Click in the rich text field, and then click Object on the Create menu.
Existing form On the View menu, click Design. Under Design in the navigation pane, click Forms. Double-click the form.
New form On the Create menu, point to Design , and then click Form.
Insert a new blank workbook Click Create a new object, and then click Microsoft Excel Worksheet in the Object type box.
Embed a copy of an existing workbook Click Create an object from a file, and then type the name of the workbook in the File box, or click Browse to select from a list.
Select the sheet to display Double-click the Excel object, and then click a different sheet.
Display a workbook icon Select the Display as icon check box.
Document On the Compose menu, click a Lotus Notes form that includes an editable rich text field, and then click in the rich text field.
Existing form On the Design menu, click Forms, click a form in the Forms box, click Edit, and then click where you want the workbook to appear.
New form On the Design menu, click Forms , click New (or click a form in the Forms box and click New Copy), and then click where you want the workbook to appear.
Insert a new blank workbook Click OK.
Embed a copy of an existing workbook Click Choose File, select the workbook you want from the list, and then click OK.
Lotus Notes 4.x Right-click the embedded workbook in the document or form, and then click Open on the shortcut menu.
Lotus Notes 3.x Double-click the embedded workbook in the document or form.
If any of the data cells are protected or contain formulas, the field will be updated in only one direction
Update fields that use Field Exchange
The following fields are two-way: Title, Subject, Author, Keywords, Comments, Manager, Company, Category, and custom properties. All other fields are one-way.
One-way fields Update one-way fields from workbook properties.
Lotus Notes 4.x Right-click the Microsoft Excel workbook inserted as an embedded object in the Notes document or form, and then click Open on the shortcut menu.
Lotus Notes 3.x Double-click the Microsoft Excel workbook inserted as an embedded object in the Notes document or form.
Two-way fields Use the above method to update two-way fields from workbook properties; or update workbook properties from the Lotus Notes fields.