Edit Links: make update manual

C

Chrissorr

I work in Excel 2003. I have a large file with about 3000 lines. It links
to another file that is about the same size (7800KB). I often move them into
new directories or change the file name. I change the source on the target
file using edit links change source. It takes 2 hours to update (I have a
relatively new laptop with 1000mb memory and a 715 processor).

I notice that the update button is always on automatic, and the manual is
grey, so I am not able to change from automatic update to manual. My
computer gets locked up for this time. I would like to change the links more
quickly. Is my problem this automatic update? Why can't I change it to
manual? Would changing to manual solve my time problem?
 
J

Jonathan Cooper

What I do...

Go to TOOLS-->OPTIONS-->CALCULATION and change it to manual. Then go into
FIND/REPLACE (ctrl+h), then type in the old file location, and the new file
location. click on REPLACE ALL.

The go back and turn the calculation back to automatic. It will still take
a while, but it shoudn't take 2 hours.
 
C

Chrissorr

Thanks Jonathan. Calculation is already turned to manual. What I have tried
is changing the formula in one cell and then copying it down the rest of the
column. I assume that would accomplish the same thing as you suggest. I
wold expect that no calculation would be down, but the link indicator comes
 
D

Dave Peterson

Maybe it would just be faster to open the new workbook. Then the links will
update faster.
 
C

Chrissorr

Thanks Dave. Definitley have new workbook open. I wonder why, in edit links,
I am prohibited from changing the update from automatic to manual (this is
the radio button). Remember calculation is already on manual.
 
D

Dave Peterson

In this post:
http://tinyurl.com/eyzjk

Bill Manville says:

Newsgroups: microsoft.public.excel.links
From: Bill Manville <[email protected]> - Find messages by this author
Date: Tue, 17 Aug 2004 14:53:50 +0100
Local: Tues,Aug 17 2004 2:53 pm
Subject: Re: Linking Manually
Reply to Author | Forward | Print | Individual Message | Show original | Report
Abuse



Emma said:
I know how to update links manually yet when I go onto
Edit, Links, the Manual option is greyed out - only the
Automatic option is available. How can I access the
Manual check box?
Click to expand...


All Excel formula links are always "automatic".
The manual option is only available for other types of links (e.g.
links to non-Excel files or to other applications).

What were you trying to achieve?


If you are using Excel 2002 or later you can specify startup behaviour
from the Edit / Links dialog, if that helps.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

====
Ps. I hate the new google!
 
Top