I'm having a strange experience, with Excel that is. In a workbook with recalc set to manual due to a substantial number =dsum() calcs, Excel is refusing to recognize existing characters when I search and replace.

(I have a bunch of detail data, one workbook per market, and I'm copying the analysis sheet from one to the other and S&R'ing the copied analysis sheet to substitute the old detail data sheet references with the new each time. Each market detail sheet name includes _ST_ where ST is US state abbreviation, and sometimes it will S&R on _ST_, and sometimes it tells me it ain't findin nothin'. Maybe it's tired.)

Anyone seen this before?