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.

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" <(E-Mail Removed)> wrote in message
news:A1D60D86-4B97-47E2-9549-(E-Mail Removed)...
> 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.

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
<(E-Mail Removed)> 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.

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.

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.