link multiple cells from other workbook on another machine on network

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryce - 09 Oct 2003 22:22 GMT

I have an entire page I updated from a workbook in another page on another
computer on the network.

I've figured out how to have it update an "image", but the the cells.

I know how to link individual cells, but not a group.

For example:

I linked 40 individual cells to the 40 individual cells on the other
workbook. Kinda took a lot of time.

Is there anyway I can automatically link A1:D40 on Sheet1 of my workbook to
A1:D40 on Sheet1 of someone else's workbook by selecting all those cells at
once? Or do I need to do them all indivudually?

Reply to this Message

DavidP - 12 Oct 2003 03:00 GMT

I don't know of any way to do all the links at one go but you
certainly do not have to do each one individually. Create your first
link by creating the formula in cell A1. Yhis will look something
like
=+[Book1]Sheet1!$A$1
Edit this to take out the absolutes ($) to make
=+[Book1]Sheet1!A1
Then copy this formula to the required range i.e. A1:D40

David

>I have an entire page I updated from a workbook in another page on another
>computer on the network.
[quoted text clipped - 11 lines]
>A1:D40 on Sheet1 of someone else's workbook by selecting all those cells at
>once? Or do I need to do them all indivudually?

Reply to this Message

Bryce - 13 Oct 2003 16:58 GMT

I will give that a shot.

Thanks!

> I don't know of any way to do all the links at one go but you
> certainly do not have to do each one individually. Create your first
[quoted text clipped - 22 lines]
> >A1:D40 on Sheet1 of someone else's workbook by selecting all those cells at
> >once? Or do I need to do them all indivudually?

Reply to this Message