Cells won't calculate

[djheffer]

I found a nifty bit of code that I used to change cell references in all my
formulas to absolute. It worked wonderfully, but now none of my formulas
calculate. I have to put the cursor into the formula bar and hit
ctrl-shft-enter. This will make a singular cell calculate, but I have over
1,000 formulas in my workbook. Is there a way to automate this task?

 

[J.E. McGimpsey]

Make sure your formula cells are formatted as something other than
Text. Do an Edit/Replace, replacing an equals sign with an equals
sign.

 

[djheffer]

Thanks for the tip. It sounded promising, but it didn't work. I've tried
the macro recorder, to record my keystrokes when I force the calculation,
but I get no useable code. Any other ideas?

I could probably force each cell to calculate one a time and have the sheet
done in three hours, but I'd rather spend two days figuring out how to
automate it.