software

i have a large workbook with several tabs and many formulas. For some
reason, even though auto-calc is turned on it will not recalc cell formulas
when i change inputs. I have to go to each affected cell, edit the cell and
hit enter to update the value. it is not a problem for =sum formulas, just
those returning a single value from another cell. Anyone experienced this
before?

Try rebuilding the dependency-tree with CTRL ALT SHIFT F9

--
Kind regards,

Niek Otten

quot;Curtquot; gt; wrote in message
news
gt;i have a large workbook with several tabs and many formulas. For some
gt; reason, even though auto-calc is turned on it will not recalc cell
gt; formulas
gt; when i change inputs. I have to go to each affected cell, edit the cell
gt; and
gt; hit enter to update the value. it is not a problem for =sum formulas,
gt; just
gt; those returning a single value from another cell. Anyone experienced this
gt; before?
thanks...do i need to do that for each tab or just once for the whole file?
what causes that problem in the first place? thanks!!!

quot;Niek Ottenquot; wrote:

gt; Try rebuilding the dependency-tree with CTRL ALT SHIFT F9
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Curtquot; gt; wrote in message
gt; news
gt; gt;i have a large workbook with several tabs and many formulas. For some
gt; gt; reason, even though auto-calc is turned on it will not recalc cell
gt; gt; formulas
gt; gt; when i change inputs. I have to go to each affected cell, edit the cell
gt; gt; and
gt; gt; hit enter to update the value. it is not a problem for =sum formulas,
gt; gt; just
gt; gt; those returning a single value from another cell. Anyone experienced this
gt; gt; before?
gt;
gt;
gt;

Once for the whole file. It shouldn't be necessary, but surely MS didn't
introduce this feature for no reason... (I think in Excel 2000, I'm not
sure)

Another way of doing this is for each sheet to find and replace all quot;=quot; with
quot;=quot;.

Do save the file.

--
Kind regards,

Niek Otten

quot;Curtquot; gt; wrote in message
...
gt; thanks...do i need to do that for each tab or just once for the whole
gt; file?
gt; what causes that problem in the first place? thanks!!!
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; Try rebuilding the dependency-tree with CTRL ALT SHIFT F9
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;Curtquot; gt; wrote in message
gt;gt; news
gt;gt; gt;i have a large workbook with several tabs and many formulas. For some
gt;gt; gt; reason, even though auto-calc is turned on it will not recalc cell
gt;gt; gt; formulas
gt;gt; gt; when i change inputs. I have to go to each affected cell, edit the
gt;gt; gt; cell
gt;gt; gt; and
gt;gt; gt; hit enter to update the value. it is not a problem for =sum formulas,
gt;gt; gt; just
gt;gt; gt; those returning a single value from another cell. Anyone experienced
gt;gt; gt; this
gt;gt; gt; before?
gt;gt;
gt;gt;
gt;gt;