Re: Name - relative reference doesn't calculate

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Biff,

the trick seems to be to get this dammend formula calculated when the
dependent cells are changed.
Some post earlier I have mentioned that I have found out that the
calculation behaviour seems to depend
on whether Excel recognizes dependents or not.

Example 1: (Excel doesn't calculate automatically, only by pressing
"Ctrl+Alt+F9:")
Formula in cell "F1" is "=SumEveryThirdValue" and "SumEveryThirdValue"
is defined as a
named formula "=SUM(!A1,!C1,!E1)".
When you check the dependecies with the detective you get no traces on
the sheet.

Example 2: (Excel calculates automatically)
Formula in cell "F1" is "=SUM(RangeSumEveryThirdValue)" and
"RangeSumEveryThirdValue" is defined as a named range "=!A1,!C1,!E1".
When you check the dependecies with the detective you get traces on
the sheet.

So the difference between Example 1 and 2 is that in Ex 1 uses a named
formula and
Ex 2 I uses a named range, which is calculated on the worksheet and
has dependent cells
(the named range).

Question is: is it logic that Example 2 works and what about
reliabilty?

Regards
Werner
.

Relevant Pages

  • Re: Calculation time
    ... calculation, and if the result doesn't change, all its dependent cells ... So to decrease the calculation time it is better to split the formula's up ... dependent upon cells that change. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Observer pattern limitations
    ... your discreet signals behave more like continuous ones. ... when B and C retrieve the output from A, A only performs its calculation ... The idea is to partition all state into independents versus dependents. ... A dependent is a value that is conceptually the result of a *pure* ...
    (comp.object)
  • Re: Using Dependents - what does the small "Table" symbol mean?
    ... Double-click the arrow to the sheet symbol and Excel will display the dependent cells ... Microsoft MVP - Excel ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Systemverilog array: .sum(), but not sign-extension?
    ... You can use a "with" expression on the reduction ... and the self-determined type of that expression ... sets the type of the calculation and the result. ... The result type of a function is not dependent on ...
    (comp.lang.verilog)
  • Re: Gravity Inside A Cylinder
    ... Care to show the calculation? ... > For infinite length rho is dependent only on r, ... > standard problem usually encountered in the basic courses (also the case ... > for constant density for r < a). ...
    (sci.physics)