Excel - Find and Replace function takes a long time

C

Chris

We have several individuals using Office 2007 and Office 2003 reporting that
the find and replace function is taking a very long time all of the sudden.
The documents they are working on are rather large, but they have been able
to use the find and replace function for several months and it would only
take a few seconds. Now all of the sudden it can take up to 2 minutes to
perform the find and replace. Any suggestions would be appreciated
 
S

Sean Timmons

If there are any formulas in the current or other open excel files, they will
recalculate with yoru replacements. Some formulas will recalcuate with every
since replacement. Is thsi the only open file? Are there new formulas in
there?
 
M

McDawg2

If all of your replacement items are in one column, highlight that column and
then run your replace, especially with text. Otherwise, I agree with Sean as
to whether a formula has changed and is recalculating.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Replace takes forever 1
Toggle between Find and Replace 4
Find and Replace Lookup errors 7
Use Find and Replace in Excel 2
Find and Replace Command 2
Find/Replace Numbers stored as Text drops zeros 1
find and replace within a hyperlink 8
How do I change the color coding with Find & Replace? 2

Top