Excel (2007) Copy and Paste function stops working

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.

JackIT ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
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
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.
JackIT ManagerAuthor Commented:
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.
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

JohnBusiness Consultant (Owner)Commented:
I notice you reference FrontPage 2003. Is this compliant with Office 2007?  

Please let us know after you apply further updates. ... Thinkpads_User
JackIT ManagerAuthor Commented:
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.
JohnBusiness Consultant (Owner)Commented:
>>> 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnBusiness Consultant (Owner)Commented:
Thank you. I was pleased to help out. ... Thinkpads_User
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.