Update-able link

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dzelnio - 25 Sep 2007 19:22 GMT

I'd like to link a worksheet with another worksheet in another excel
file. Instead of having a "live" link, I'd like it to up an
updateable link.

Any such thing?

Dave

Reply to this Message

Bob Greenblatt - 26 Sep 2007 12:59 GMT

On 9/25/07 2:22 PM, in article
1190744573.006111.64420@n39g2000hsh.googlegroups.com, "dzelnio"

> I'd like to link a worksheet with another worksheet in another excel
> file. Instead of having a "live" link, I'd like it to up an
[quoted text clipped - 3 lines]
>
> Dave

I'm not sure what you mean. A link in one workbook to another is "live" when
both are open.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

CyberTaz - 27 Sep 2007 11:42 GMT

Are you referring to the setting for Manual v. Automatic updating of the
Links? That only applies if you're linking to an object other than another
Excel file. Since all files of the same type share the same application RAM
manual updating isn't an option - the client will update any time it is open
while the server file is being changed.

However - if the box is checked in Excel> Preferences> Edit - "Ask to update
Automatic Links" the Links will *not* automatically update when you open the
client file - if the server file is not open at the time.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 9/25/07 2:22 PM, in article
1190744573.006111.64420@n39g2000hsh.googlegroups.com, "dzelnio"

> I'd like to link a worksheet with another worksheet in another excel
> file. Instead of having a "live" link, I'd like it to up an
[quoted text clipped - 3 lines]
>
> Dave

Reply to this Message

Mac Forum / Applications / Excel / September 2007

Update-able link