Not summing a columns?
When summing a column in Excel 2000. If additional numbers are added the
formula does not recalculate the amount. Unless I click on the formula in the
formula bar again and press enter. Then it works fine. Is there a way to make
it calculate automatically? It was working fine. Is there an option I turned
off somewhere?
Thanks,
|