Excel 2007 Copy and Paste Formulas stopped working

Posted on 2012-03-28
Medium Priority
Last Modified: 2012-06-27

A workstation running XP SP3 and Excel 2007 stopped working correctly.  

The copy and paste of formulas no longer works, rather it pastes the values of the cell.

I checked to make sure auto calculate was checked in the excel preferences.

I can also no longer insert cut columns from one part of a worksheet to another.

Thank you for your help.
Question by:networkadmin
  • 2
  • 2
LVL 81

Expert Comment

ID: 37780060
Are you copying and pasting from one Excel instance to a workbook in another Excel instance? If so, copying a cell from one workbook to the other one will bring over just the value, not the formula. You can tell that they are in different instances of Excel because you cannot see the target workbook in the View...Switch Windows menu item.

Author Comment

ID: 37780284
We are copying from the same instance and the same workbook.
LVL 85

Accepted Solution

Rory Archibald earned 2000 total points
ID: 37780730
Is it just one workbook, or all of them? If only one, there may be code in it. If all, it may be an addin, or there have been issues reported with pasting (though generally paste special) if you have the Skype Click to call plugin in Internet Explorer.

Author Comment

ID: 37782236
It is all workbooks.  I will try to disable skype and see if that works.  Could this be related to acrobat?
LVL 85

Expert Comment

by:Rory Archibald
ID: 37782276
Conceivable I suppose but I've never heard of it causing that problem (others, sure, but not that one).

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question