I have an overall Excel workbook that is pulling information from 3 other
workbooks. Upon updating information in the 3 workbooks, I now need to
update my cell range in the overall. I am currently doing a find and replace:

Find: $156
Replace $500

I use the dollar signs because I have lines with 156 as reference that cell
line. Anyway when I do this, a window pops up asking for the correct
spreadsheet file. For every cell that is being updated, it asks this. There
are at least 500 cells that need to be updated. Why is this doing this? And
is there a way to avoid this and just update the cell information?

Thanks in advance.