Updating External Links

[DCSwearingen]

I have several large spreadsheets linked to other large spreadsheets.

I looked in Help and found

"Change the way a linked object is updated On the Edit menu, click Links.

The Links command is unavailable if your file does not contain linked information.

In the Source file list, click the linked object you want to update.
To select multiple linked objects, hold down CTRL and click each linked object.

To update a linked object every time you open the file that contains the object or any time the original information changes while the file is open, click Automatic.

To update a linked object only when you click Update Now, click Manual. "

I do not want them to automatically update when I open them. However, the option to only update manually is not available to me. The manual radio button is grayed out.

When I open the spreadsheets, I am asked whether to update remote links and always click No, but they update anyway.

How can I stop this activity as these large spreadsheets seem to tie up almost all of my system resources during this refresh cycle.

[PancakeBatter]

Hi DC- Same thing on my Excel 2002. However, the prompt that appears at file
open will not update my link data if I choose it. Then, I can Edit, Links,
Update Values to update manually. Maybe breaking the link and then creating
it again would help.

Also, checkout Tools, Options, Calculation tab, Save External Values
section. Maybe this applies to your situation.

PB

"DCSwearingen" wrote:

>
> I have several large spreadsheets linked to other large spreadsheets.
>
> I looked in Help and found
>
> "Change the way a linked object is updated On the Edit menu, click
> Links.
>
> The Links command is unavailable if your file does not contain linked
> information.
>
> In the Source file list, click the linked object you want to update.
> To select multiple linked objects, hold down CTRL and click each linked
> object.
>
> To update a linked object every time you open the file that contains
> the object or any time the original information changes while the file
> is open, click Automatic.
>
> To update a linked object only when you click Update Now, click Manual.
> "
>
> I do not want them to automatically update when I open them. However,
> the option to only update manually is not available to me. The manual
> radio button is grayed out.
>
> When I open the spreadsheets, I am asked whether to update remote links
> and always click No, but they update anyway.
>
> How can I stop this activity as these large spreadsheets seem to tie up
> almost all of my system resources during this refresh cycle.
>
>
> --
> DCSwearingen
>
>
> ------------------------------------------------------------------------
> DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
> View this thread: http://www.excelforum.com/showthread...hreadid=504633
>
>