Formulas that have always automatically re calculated formulas no longer do
unless F9 is pressed. Settings are on calculate automatically
Try selecting all the cells and then:
edit|replace
what: =
with: =
replace all
Maybe it'll wake excel up.
Archie wrote:
gt;
gt; Formulas that have always automatically re calculated formulas no longer do
gt; unless F9 is pressed. Settings are on calculate automatically
--
Dave Peterson
The first response didn't work, but made me think, I went to options changed
to Manual under Calculations, re-opened options and changed back to
automatic...this woke up excell...thanks for the push
quot;Archiequot; wrote:
gt; Formulas that have always automatically re calculated formulas no longer do
gt; unless F9 is pressed. Settings are on calculate automatically
- Nov 18 Sat 2006 20:10
Not Automatically Calculating Formulas
close
全站熱搜
留言列表
發表留言