Solved

Excel (2007) Copy and Paste function stops working

Posted on 2012-03-22
7
479 Views
Last Modified: 2012-06-21
Hello,
Two days ago the copy and paste function stopped working correctly on Excel.
Basically if I do CTRL-C or right click copy, or hit copy at the top left I can just see the cell or cells highlight border flash with the normal kind of moving outline you get with when a cell is copied. After this it is just as if nothing happened, the cell looks normal.

If I then go to paste, the data will paste fine, it is in the clip board and I can see it appear. However, if I have selected full rows or a column and I then want to Insert copied rows/columns I can't as the only option is "Insert", not "insert copied cells". This is very annoying as I need to use the function a lot.

I did a "Repair" install and it fixed it but 5 minutes after using it normally again it just went back to the way it was.

It is unique to Excel, Word, Outlook etc do not seem to be affected with the C&P function.

Any help would be greatly appreciated.

Thanks,
Jack
0
Comment
Question by:JackHodson
  • 4
  • 2
7 Comments
 
LVL 90

Expert Comment

by:John Hurst
ID: 37752958
If the Repair did not work (does not always), do a full uninstall of Office 2007.

Now before reinstalling, run System File Checker (SFC /SCANNOW) and allow to complete. Restart. Re-run if errors.

Now install Office 2007 again (full not typical except for languages foreign to you). Update all 3 service packs and patch.  

... Thinkpads_User
0
 
LVL 30

Expert Comment

by:flubbster
ID: 37754766
Check excel settings and see if autosave is enabled. This can sometimes cause issues. If it is, disable it, exit excel, then start it again and test it.
0
 
LVL 4

Author Comment

by:JackHodson
ID: 37776967
Hi there,
Many thanks.
I have so far:
Removed Office, Rebooted, Installed Office - No change
Removed Office, Rebooted, SFC /SCANNOW, Rebooted, Installed Office, Updated with SP2 - C&P worked normally for a few mins then it went back to how it was.

I have noticed that C&P fails to work correctly in Word as well as between programmes to MS FrontPage 2003. Data will copy and paste but without any formatting options.

I am now apply a further set of updates for Office. I will let you know how it goes.
Jack
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 90

Expert Comment

by:John Hurst
ID: 37777387
I notice you reference FrontPage 2003. Is this compliant with Office 2007?  

Please let us know after you apply further updates. ... Thinkpads_User
0
 
LVL 4

Author Comment

by:JackHodson
ID: 37786299
I don't know about compliance but I have used the two together now for 4 years and no issues until now. All Office updates are installed and unfortunately the C&P is still not working properly.
0
 
LVL 90

Accepted Solution

by:
John Hurst earned 500 total points
ID: 37786552
>>> I don't know about compliance but I have used the two together now for 4 years and no issues   <--- Ok, then, that will not be the problem (at least not likely).

If you have done everything you can do (Uninstall, reinstall, patch, System File Checker) and it still does not work, then you may need to re-install Windows.

... Thinkpads_User
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 37835461
Thank you. I was pleased to help out. ... Thinkpads_User
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now