How to link workbooks in Excel

Asked By lance wyle 200 points N/A Posted on - 10/27/2011

When using Microsoft Excel, it is easy to link up Workbooks.

But since I am using the Millennium version of Lotus, I can’t find a way to do it. 

Please let me know if anyone of you has knowledge on how to fix this. 

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

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Zorian Crust

Go To Solution

Best Answer

Best Answer

Answered By Zorian Crust 80 points N/A #129159

How to link workbooks in Excel

Hi Lance,

Good day!

First, I suggest you to arrange the windows in the files in workbook  that you want to link in excel. By doing this, you can easily see the cells that you want to link. Next is go to the cell where you want to link the formula and then just type the formula.

And then highlight or just simply click the cells in the other file and just click enter on your keyboard. This solution is very effective. I've used it many times and never fails me.

I hope that it helps you solve your issue either.

Happy weekend to you!

Zorian.

About Zorian Crust

Questions
0

Answers
377

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 10/28/2011
• Question Category: MS Excel

Answered By Mohamed Syalah 0 points N/A #129160

How to link workbooks in Excel

we can link two workbooks by link two cells with each other, where any change in one workbook affect in other one. 

open two workbooks named book1.xlsx and book2.xlxs

write in book1 cell A1 "="   and go to book2 click in cell A1 and press Enter key

now write anything in book2 cell A1 and press Enter key, you will see what you write in book1 immediately 

In this way you can link workbooks in EXCEL"My Love".

 

About Mohamed Syalah

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/29/2011
• Question Category: MS Excel