Thank you both for your help.

Unfortunately I was not able to use the edit links function because I was
only changing the tab it referenced, not the workbook. (unless you know
something I don't know)

But, after a little more trial and error with a comination of your
suggestions I was finally able to get it to work...it still took a few
minutes, but it completed without crashing excel.

BTW - the most crutical thing I forgot was to open the linked
workbook...duh! Sometimes the most obvious thing is all it takes....

Thanks Again,

Diane

"Lori" wrote:

If there's just one filename, why not just change the link by double-
clicking the old file name in the Edit Links dialog, this seems
simpler than the Replace method in the original post as well.

On Jan 22, 4:43 pm, Dave Peterson wrote:
If you open the "sending" file, does it work faster?





diaare wrote:

Sorry to revive such an old tread, but I am attempting to do the same thing.

Here is what I have tried to so far:

I converted all the formulas to text by using the find = and replace with
$$$=. This was very fast.

I changed my workbook reference from jan-june to july-dec using the find and
replace. Again this was very fast.

Here is my hangup...

When I attempt to change the $$$= back to = using find and replace it slows
excel to a halt, and I end up having to use task manager to get out of it.

This even happens when I have manual calculations turned off.

Is there a step I am missing to complete this process, or am I going about
this all wrong?

Thanks,

Diane

"pshepard" wrote:

Hi Rob,

Try doing a search and replace = sign with the = sign, then recalc..

Let me know how that worked.

Thanks,
Peggy

"Rob" wrote:

this is my formula
='H:\EXCELDAT\MATRIX\CM2006\[DKBSD06.XLS]FLAT BSD #2 PT'!$D$288
i need to change CM2006 to COST MATRIX 2006 in a column containing 3,500
cells.

when selecting a 3,500 cell column to replace items in the formula, i am
allowed to replace one by one, but when select replace all, excel returns $0
and then locks up.

help?

--

Dave Peterson- Hide quoted text -

- Show quoted text -