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.

Michelle ... (Hi)

Not sure I understand your ? totally ... However, if you are looking to
find/replace $156 with $500 in the Overall Book ... then select the entire
Range where $156 exist & then select "Replace All".

HTH or at least gets you on your way ... Kha

"Michelle" wrote:

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.

Hi Ken

Thanks for your response. Yes, that is what I did...I selected "replace
all".

For example,
I have an overall workbook that pulls information from Workbook 1, Workbook
2, Workbook3. Let's say workbook3 is located at c:\budgets\workbook3.xlsm

When I click on replace all, the message box comes up asking where workbook3
is mapped. I then need to find c:\budgets\workbook3.xlsm and select it for
every cell that I am updating.


"Ken" wrote:

Michelle ... (Hi)

Not sure I understand your ? totally ... However, if you are looking to
find/replace $156 with $500 in the Overall Book ... then select the entire
Range where $156 exist & then select "Replace All".

HTH or at least gets you on your way ... Kha

"Michelle" wrote:

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.