| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link multiple cells from another workbook?
How do I link multiple cells at the same time, between the source workbook
and the destination workbook? When I select multiple cells at a time, it only links the first cell in the range. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I link multiple cells from another workbook?
Copy a range from source workbook.
Switch to destination workbook. Select a single cell and EditPaste SpecialPaste LinksOKEsc Gord Dibben MS Excel MVP On Thu, 30 Oct 2008 09:50:49 -0700, Deb T <Deb wrote: How do I link multiple cells at the same time, between the source workbook and the destination workbook? When I select multiple cells at a time, it only links the first cell in the range. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I link multiple cells from another workbook?
Hi,
And if you are using 2002 or later you can do the copy and in the destination workbook open the Paste drop down button and choose Paste Links -- Thanks, Shane Devenshire "Deb T" wrote: How do I link multiple cells at the same time, between the source workbook and the destination workbook? When I select multiple cells at a time, it only links the first cell in the range. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link cells in a workbook and be able to sort differently | New Users to Excel | |||
| How do I link cells from a workbook, to talley one one sheet? | Excel Worksheet Functions | |||
| How do I break a link between cells in the same workbook? | Excel Discussion (Misc queries) | |||
| Cells to link to "current workbook" | Excel Discussion (Misc queries) | |||
| Can't link cells in worksheets in same workbook | New Users to Excel | |||
Linear Mode
