my formulas won't copy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 :-)
------------------------------­------------------------------­----------------
 
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
 
Back
Top