View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tazatha tazatha is offline
external usenet poster
 
Posts: 5
Default formulas not auto calculating and will not calculate

an excel spreadsheet created by fox pro 9.0 will not calculate the formulas.
They appear as the formula such at =H2*(100+O2)/100
clicking on the cell will not allow it to recalculate. rekeying the formula
some where else in the spread sheet will not calculate. if i copy the lines
from the spreadsheet and put them in a blank spread sheet it will not
calculate. if i retype the formula in another cell farther down the new
spreadsheet and hit enter. the formula will calculate. what is getting set
or changed or what? to prevent formulas from calculating?

--
tazatha