Formula copy problem: only text value paste allowed

This issue is a real problem for me. Anyone???

Is your sheet protected? Are the cells merged? Can you upload a sample workbook?

Thanks Whizbang!

Resolution: It looks like it was coming from a conflict for the clipboard with another program that was usually running. I've learned to stop the other program and clear the clipboard with the shortcut: C:\Windows\System32\cmd.exe /c "echo off | clip"

I have the same problem, but I am not being able to solve it with your shortcut. COuld you give me further details of hot to do that?

Exact same problem here (very well described sanchius) - copy and paste results in values only, formulas are not being pasted. This occurs across all worksheets (even new blank ones). Restarting the computer, closing applications and clearing the clipboard (delete all), does not help.

While it was not enough to exit all programs and clear clipboard, the problem was solved by deleting all programs in autostart, and re-booting computer. Copy and paste function worked properly again (dotted lines around copy box returned, etc). I then opened all programs one-by-one, and the problem re-occured when I opened Skype. This may have something to do with the latest Skype add-in, 'click to call' - which I installed yesterday. I will delete this add-in, reboot, and hopefully get some work done.

Disabling the Skype add-on in Internet Explorer also solved the problem for me. Then, I uninstalled Skype Click-to-Call which removed the add-on (and the problem).

I have been going mad trying to copy a formula, such a simple process, but kept getting a text result. Deleting the skype app has resolved it - I would never have got there without this forum - thank you!

I just started having a similar experience. I don't use Skype but it prompted me to check what other programs I'm using and found that it happens when I'm using VNC to take over a different PC. Glad to find a reason for it.

Ugh I'm having the same trouble and don't have Skype on this network. Guess I'm going to have to go through them all one at a time. Thanks for the info though, this helps me pin down where to start.