Excel 2007 - Pasting values instead of formulas

[MrKowz]

Hey everyone,

I am having a rough time trying to figure this one out. My HR Manager's Excel (2007) copying/pasting is malfunctioning. When we try to copy a function (ctrl+C) and paste (ctrl+V), it is pasting the value rather than the function. I've tried a new worksheet, a new workbook, etc, and it appears to be an Excel-wide issue (even in a new workbook, I can put 1 in A1, 2 in A2, put the formula =A1+A2 in A3, and then when I copy/paste A3 to A4, it places the value of 3 instead of the copied formula). Is anyone else experiencing this problem, and know of a fix?

Thanks!

 

[XL&ME]

Glad that to hear that ZVI's suggestion worked for you.

 

[Colin Legg]

Great work!

 

[malcolm99]

Recently found that using VNC to take over a remote PC also causes the problem.