Help- cell formulas not 'inactive'

[Uncle Vinnie]

Something strange is happening and I'd like to ask for your help.

I have a workbook containing about 30 tabs- each the same- they are a
product order sheet but the only difference is the bill and ship info,
different for each, but all else identical.

When I enter a number in the 'quantity each' cell, it should break out into
a certain size scale- in other words, if I enter 12 in the 'each' column, 6
should fill in the 'small' cell, 3 in 'medium', 3 in 'large'. The formula
is in the cell- small is set up as =F30/2, Medium =F30/3, Large =F30/3.
Then subtotal is set as total*cost each... etc..

It has worked for years... the only thing I can think of is that I added
another sheet (account) in the middle by copying a sheet and adding it.

This is happening in all of the fields- the sub totals, grand totals, units,
dollars, etc... and the recap page, which gets it's numbers from certain
boxes on the each of the sheets- same thing... I have to go to each cell
individually, click on it, make the formula appear in the top box and hit
'enter' for it to calculate the number...anyone know why all the cells are
'dead'???

Using Office 2000, btw... Thank you very much!

 

[Uncle Vinnie]

OOPS... I meant cell formula's inactive!!!

 

[Peo Sjoblom]

I find that by replacing the equal sign with the equal sign it makes the
formulas calculate as formulas
more often than not. So do edit>replace, in find what put = and in replace
with put =, then select replace all..
As I recall it used to happen more frequently with excel97 than with later
versions

 

[Niek Otten]

Hi Vinnie,



Most frequent reasons for not recalculating:



A. Automatic calculation is an Excel-wide setting
(Tools>Options>Calculation). If you load a workbook

which has Manual calculation and then load another workbook which had

Automatic calculation, they'll both be set to Manual calculation.

B. Excel 5.0a and Excel 97 without Service Release 2 have recalculation

bugs. Update to a newer version (for Excel 97, that is, apply SR2)

C. User defined Functions (UDFs) should have all direct precedent cells in

the argument list. If you address a cell directly from within the UDF, Excel

doesn't know so it doesn't know when to recalc. This is true for both VBA

and Excel4 functions.

D. Very rarely (really, very, very, rarely!) Excel loses track of

dependent/precedent cells. In ExcelXP you can rebuild the dependency tree by

pressing CTRL+SHIFT+ALT+F9. In all versions you can do it sheet by sheet, by
Finding all "=" and replacing all with"=".


--
Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Uncle Vinnie]

Thank you Peo, Thank you Niek-

It was the Options setting.. it was set at 'manual'! I never knew that
option existed and now it's fixed.. and all works!!

Thank you very much!

 

[BrianB]

You have probably set calculation to manual. Reset to automatic via
Tools/options/Calculate.

Regards
BrianB
====================================================

 

[Uncle Vinnie]

Thanks Brian... yes, that was it...

You have probably set calculation to manual. Reset to automatic via
Tools/options/Calculate.

Regards
BrianB
====================================================


"Uncle Vinnie" <[email protected]> wrote in message