Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DDE Link formatting
Can anyone tell me the sytax for a simple link to a cell in another excel
file on the c drive ? Not for visual basic but the formula for a spreadsheet cell. I used to know it but haven't used it in years. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DDE Link formatting
ORLANDO V,
There is nothing simple about that. Just open both source and destination files. In the destination file in any cell, type an equal sign, switch to the source file, pick a cell and hit enter. Now close the source file and look at the formula in the cell in the destination file. HTH, Conan "ORLANDO V" wrote in message ... Can anyone tell me the sytax for a simple link to a cell in another excel file on the c drive ? Not for visual basic but the formula for a spreadsheet cell. I used to know it but haven't used it in years. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
DDE Link formatting
Open both workbooks then in target workbook cell enter an = sign.
Switch to source workbook and select a cell then hit ENTER key. Gord Dibben MS Excel MVP On Thu, 13 Dec 2007 13:55:01 -0800, ORLANDO V wrote: Can anyone tell me the sytax for a simple link to a cell in another excel file on the c drive ? Not for visual basic but the formula for a spreadsheet cell. I used to know it but haven't used it in years. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
DDE Link formatting
Thanks.
"ORLANDO V" wrote: Can anyone tell me the sytax for a simple link to a cell in another excel file on the c drive ? Not for visual basic but the formula for a spreadsheet cell. I used to know it but haven't used it in years. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
DDE Link formatting
Thank you.
"ORLANDO V" wrote: Can anyone tell me the sytax for a simple link to a cell in another excel file on the c drive ? Not for visual basic but the formula for a spreadsheet cell. I used to know it but haven't used it in years. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link Cell Formatting | Excel Discussion (Misc queries) | |||
Formatting action activated link | Excel Worksheet Functions | |||
How can I link a cell in Excell and keep the same formatting? | Excel Worksheet Functions | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
How do I link a cells formatting from one worksheet to another? | Excel Worksheet Functions |