| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking a cell
Hi,
i would like to link a cell from an other workbook, but i can't. even if i try tu use paste special, i get some different window than usual. could sy help on me? thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking a cell
with the source workbook open, go to the destination workbook and cell, type
"=" then go to the source workbook and cell and hit enter "Gábor" wrote: Hi, i would like to link a cell from an other workbook, but i can't. even if i try tu use paste special, i get some different window than usual. could sy help on me? thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking a cell
thx, but unfortunatelly its more complicated. i often use this way, but it
does not work in this case and i do not know why :-( i see the "=", but when i select the source cell does not happen anything "lk" wrote: with the source workbook open, go to the destination workbook and cell, type "=" then go to the source workbook and cell and hit enter "Gábor" wrote: Hi, i would like to link a cell from an other workbook, but i can't. even if i try tu use paste special, i get some different window than usual. could sy help on me? thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking a cell
depending on what you are doing, you may or may not need to have the source
worksheet open and you may need to update your links. (Edit Links) "Gábor" wrote: thx, but unfortunatelly its more complicated. i often use this way, but it does not work in this case and i do not know why :-( i see the "=", but when i select the source cell does not happen anything "lk" wrote: with the source workbook open, go to the destination workbook and cell, type "=" then go to the source workbook and cell and hit enter "Gábor" wrote: Hi, i would like to link a cell from an other workbook, but i can't. even if i try tu use paste special, i get some different window than usual. could sy help on me? thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking a cell
so, i recognized for now that the sheet was protected and that's why i could
not put a link into the cell. thanks for your help! G. "lk" wrote: depending on what you are doing, you may or may not need to have the source worksheet open and you may need to update your links. (Edit Links) "Gábor" wrote: thx, but unfortunatelly its more complicated. i often use this way, but it does not work in this case and i do not know why :-( i see the "=", but when i select the source cell does not happen anything "lk" wrote: with the source workbook open, go to the destination workbook and cell, type "=" then go to the source workbook and cell and hit enter "Gábor" wrote: Hi, i would like to link a cell from an other workbook, but i can't. even if i try tu use paste special, i get some different window than usual. could sy help on me? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| linking to a cell within a text cell or comment | Excel Worksheet Functions | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
Hybrid Mode
