Cells won't calculate

  • Thread starter Thread starter djheffer
  • Start date Start date
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?
 
Make sure your formula cells are formatted as something other than
Text. Do an Edit/Replace, replacing an equals sign with an equals
sign.
 
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.
 
Back
Top