How to link workbook using lotus?

Asked By nathan jones 0 points N/A Posted on - 11/04/2011

Hi!

I am using the Millennium version of Lotus and I cannot link up workbooks. Although in Microsoft Excel this is very simple, in Lotus I can’t find the proper way to do it.

Please let me know if you’ve got any knowledge of how this operation can be done. 

• Status: Open
• Question Views: 819
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: OS

Best Answer by talki rathy

Go To Solution

Answered By Clair griffin 10 points N/A #105263

How to link workbook using lotus?

 

Hello there! It is very easy to link workbooks using lotus. It is just a matter of copy and paste. First, open the lotus file that you want to link to another workbook. Highlight the cells that you want to link and press Ctrl + C to copy it. Now, open the workbook where you are going to place the link. Highlight the cells where you want the link to appear and press Ctrl+V. You will need to right click the bottom right corner of the pasted data and select Paste Special. Check the Link box and that's it. Link done!

About Clair griffin

Questions
1

Answers
132

Best Answers
38

• Vote Up 0 Vote Down

• Posted on - 11/04/2011
• Question Category: OS

Best Answer

Best Answer

Answered By talki rathy 0 points N/A #105264

How to link workbook using lotus?

Hi Jones,

Here is the solution:

1. Open your excel file that you need to link

2. Drag the mouse to choose multiple cells in your workbook that you need to link with another workbook

3. Press ctrl+c to copy the information

4. Open your excel file that you need to link with original file

5. Press ctrl+v to paste the data in workbook

6. Go to menu and select the Link cells option.

7. Now, open your lotus file that you need to link with workbook

8. Drag the mouse by right clicking and select multiple cells to link with workbook

9. Copy the data by pressing ctrl+c

10. Open your lotus file that you need to link with workbook

11. Press ctrl+v to paste the data

12. Go to ‘Menu’ and select ‘paste special’. ‘Link box’ should be checked. ‘Insert all’ option should be checked and click ‘OK’. 

About talki rathy

Questions
5

Answers
100

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 10/03/2012
• Question Category: OS