With thousands of formulas,. Excel may be recomputing many, many thousands
of times. As each $$$= becomes =, Excel may be computing the formula. This
could be very, very time consuming. The question is: what are you trying to
do? You did not tell us.

Tyro

"diaare" wrote in message
...
I need to change thousands of formulas on a worksheet. Afeter reading some
other posts in this forum, I thought I could do it using find and replace.

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