Yes.  I've found a couple of workarounds for what I need to do.  Because I
really only need the formula results for the hypothetical data I'm entering
(to compare it to "real" data as it comes in), I'm just pumping hypothetical
data into my real data worksheet and then copying the values over to a new
worksheet (and reverting the real data to...real data).  What makes it easy
for me is that my formulas won't change, so perhaps someone else who has that
need will need to solve that mystery.

Unfortunately, although it did cause me to have an "Eureka!" moment, your
fix would have been somewhat tedious; the example I gave was the simplest
formula I had.  I would have had to replace a ton of values (G through DA; G$
through $DA) for that to have worked, I think.

Seems to me all solutions to this problem would have been tedious, though,
if my formulas were to change around in the future.