Excel copy-paste is only copying as values, but I want it to copy formulas

2

In Excel, imagine the following numbers in these cells:

A1: 5 B1: 6 C1: =A1+B1 [Displays 11]

A5: 7 B5: 8 C5:

If I copy cell C1 and paste into C5, rather than copy the formula, which is what I want, it only copies the value of 11. I am specifically not doing a paste-special as values. One strange thing that I have noticed is that sometimes copy-paste works fine but it seems like after a few minutes it always breaks as I have just mentioned. I know it is broken because when it works correctly, the copied cell (C1 in this example) remains highlighted and the border of the cell has the "walking ants" around its border. When Excel is not broken, the walking ants cease.

I have tried to uninstall and reinstall Excel but the issue came back rather quickly.

Does anyone know what might be going on? I use Excel 2010.

EK09

Posted 2012-04-15T12:54:24.787

Reputation: 21

Question was closed 2013-01-24T12:37:48.877

1For future reference, if the "walking ants" disappear, that means the clipboard has changed since you told Excel to copy (or cut). – Bavi_H – 2012-05-01T01:19:26.190

Answers

2

Try paste special as formula, and if you want the destination cell show you the same formula you need to replace A1 to $A$1 and so on - that's because $A$1 - is an absolute path whereas A1 is an relative one.

cookieMonster

Posted 2012-04-15T12:54:24.787

Reputation: 149

The paste-special as formula option is no longer an option when this error occurs. However, another forum notified me that a Skype add-in is probably causing the issue. I deleted the Skype add-in and for now Excel is working fine. – EK09 – 2012-04-15T22:39:46.233

Asked: 2012-04-15T12:54:24.787

Viewed: 4 213 times

Active: 2012-05-27T14:19:19.993