Chris have you tried Edit, Find and Replace?
Copy all formulas into your worksheet then Edit, Find and Replace and
complete 'Find what:' Field 3 & 'Replace with:' Field 4 then you can 'Replace
All' or 'Replace' (replaces one entry at a time)
Does this help?

"Chris J." wrote:

I am trying to reference a cell in a different workbook. If I do each
individual reference with my mouse it works, but i have a lot of sheets to do
so I wanted to be able to copy and paste but it won't work.

I have one workbook that references all the others using the formula
='[04F1-10a.xls]Field 3'!$B$4. I want to be able to change field 3 to 4,5,6,
etc. When I copy the one formula multiple times it will display "4-3" which
is correct. but then when i try to change the 3 to a 4 it should display
"4-4" but instead it just displays the formula.