View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Excel ignoring previously entered formulas

Make sure calculation is set to automatic:

ToolsOptionCalculation

Biff

"mijoh" wrote in message
...
Hi,

I created an Excel template worksheet using several various formulas. When
I
attempt to use the template, excel is ignoring the formulas unless I click
into the cell containing the formula. Anyone know why this happens?