ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formulas Becoming Inactive?!? (https://www.excelbanter.com/excel-worksheet-functions/167753-formulas-becoming-inactive.html)

Barton

Formulas Becoming Inactive?!?
 
I am working on a Spread sheet I have a formula and it has been working for a
while now and sometimes it just becomes inactive it no longer calculates the
fields. Just an fYI am using the #DIV/0! How do I make it active again?
Please Help! Thanks!


David Biddulph[_2_]

Formulas Becoming Inactive?!?
 
Tools/ Options/ Calculation: Automatic, not Manual.

Otherwise, you might need to give us some more information, as there's a
limit to how well we can guess what you've done.
--
David Biddulph

"Barton" wrote in message
...
I am working on a Spread sheet I have a formula and it has been working for
a
while now and sometimes it just becomes inactive it no longer calculates
the
fields. Just an fYI am using the #DIV/0! How do I make it active again?
Please Help! Thanks!





All times are GMT +1. The time now is 03:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com