| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel is turning entered dates into formulas despite format. Why? | Excel Discussion (Misc queries) | |||
| Previously good formulas wont run. What have I done wrong? | Excel Worksheet Functions | |||
| Ignoring Formulas within cells | Excel Worksheet Functions | |||
| Can Excel recognize when data is entered and apply formulas? | Excel Worksheet Functions | |||
| Ignoring formulas in Custom Headers | Excel Discussion (Misc queries) | |||
Hybrid Mode
