| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
link two workbooks
When I link cells in different workbooks, I select the destination cell, type
=, and then go to the source cell in the 2nd workbook and select it. In Office 97, can you start the linking process at the source cell rather than the destination cell? |
|
#2
|
|||
|
|||
|
Sure. Copy the source cell. Select the destination cell and pick Edit, Paste
Special, Paste Link. Then press Esc to exit Copy mode.. -- Jim Rech Excel MVP "Tracey" wrote in message ... | When I link cells in different workbooks, I select the destination cell, type | =, and then go to the source cell in the 2nd workbook and select it. In | Office 97, can you start the linking process at the source cell rather than | the destination cell? |
|
#3
|
|||
|
|||
|
That's simple enough. Thanks.
"Jim Rech" wrote: Sure. Copy the source cell. Select the destination cell and pick Edit, Paste Special, Paste Link. Then press Esc to exit Copy mode.. -- Jim Rech Excel MVP "Tracey" wrote in message ... | When I link cells in different workbooks, I select the destination cell, type | =, and then go to the source cell in the 2nd workbook and select it. In | Office 97, can you start the linking process at the source cell rather than | the destination cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
| Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
Linear Mode
