find and replace does not work in a linked cell

G

Guest

I have a column in a worksheet that contains links to other cells within the
same workbook, i.e. formula is ='lease Aug 2005'!F20. I want to perform a
find on Aug and replace it with Sept (to update the cells with September's
information) but am having no luck. It keeps looping into an "Update Values"
dialog box. The workbook was originally created in Excel 2000 and I am now
using Excel 2003. Any suggestions would be most welcome.
 
G

Guest

Hi Judith-

You're definitely on the right track, but you're missing one key ingredient.
Before you use Find & Replace, go to Tools>Options-View and put a check in
the box for 'Formulas'. Once you do your F&R go back to remove the check.

HTH |:>)
 

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 and Replace 1
Find/Replace 2
Link behavior with changing data set 3
Paste Values in linked Cells Only 4
Looping PoewrPoint Show linked to Excel 2
How to find linked cells 1
Cells act as if they are linked-link does not display in entry bar 1
Find and replace macro 3

Top