How to link workbook using lotus?

Asked By 0 points N/A Posted on -
qa-featured

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. 

SHARE
Best Answer by talki rathy
Answered By 0 points N/A #105263

How to link workbook using lotus?

qa-featured

 

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!

Best Answer
Best Answer
Answered By 0 points N/A #105264

How to link workbook using lotus?

qa-featured

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’. 

Login/Register to Answer

Related Questions