ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel ignoring previously entered formulas (https://www.excelbanter.com/excel-worksheet-functions/140097-excel-ignoring-previously-entered-formulas.html)

mijoh

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?

T. Valko

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?




mijoh

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?





T. Valko

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