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

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