Cells won't calculate

D

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

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.
 
D

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.
 
Top