when I pasted a group of copied cells with formula in from one file to another (opened by two Excel programs windows at same time). all formula disappeared. just like "paste special-value only". When i checked the menu of "paste special", there was no options but "HTML/Unicode/text". Can anyone help me to find out how to get the cells in one file pasted to another under a different window without losing the formula? Thanks in advances,



sandy,