![]() |
Excel ignoring previously entered formulas
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? |
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? |
Excel ignoring previously entered formulas
That answered my question.
Thanks for the help "T. Valko" wrote: 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? |
Excel ignoring previously entered formulas
You're welcome. Thanks for the feedback!
Biff "mijoh" wrote in message ... That answered my question. Thanks for the help "T. Valko" wrote: 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? |
All times are GMT +1. The time now is 03:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com