User Copies cells with formulas, gets values

[benah]

I have a user copying a set of cells from one workbook to another. The source workbook has formulas in the cells, however, after coping the cells to the target workbook the result is only values.

Excel 2000 (SR-1)

Thanks in advance.

 

[MargaretB]

I am wondering if your user is using "Paste Special" to copy. When I just use "Paste," it is the same as choosing "All" from "Paste Special." Then it includes formulas. (The Edit menu has the "Paste Special" option.)

In any case, if the user selects "Paste Special" and chooses either "Formulas" or "All," the formulas should be copied.

I hope this answers the question. Sometimes you just have to watch them do it.

 

[benah]

Yea, I’m a bit suspicious, however, they are adamant that they are right clicking and choosing paste. Is there some sort of default option to select so that standard copy is interpreted as paste-special values only?