my formulas won't copy

[Linden 1]

Hi -
When I change a number excel won't change it thru the formulations. In other
words I have to manually go thru and change each number then re enter the
formula. Is there a "freeze"in Excel that won't allow any changes?

Any help is appreciated.

 

[Ken Wright]

Tools / Options / Calculation Tab / Change manual to automatic.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[DAR]

When I copy from a worksheet, either an entire worksheet or a highlighted
group of cell, the contents paste but not the formulas. In my calc tab
"automatic" is checked. Any other suggestions? Thanks