Solved

Excel 2010 will not paste formulas

Posted on 2012-03-12
19
1,473 Views
Last Modified: 2012-06-27
My Excel is acting up. When I copy and paste.  It will not paste the formulas. When I right click, only the text option is available.  I have done the following:

Reboot
scandisk
removed office 2010 and reinstalled
open only one application of Excel with only one Excel 2010 xlsx file open.

With this I still have the problem.  It is not the file.  The same file works file on my desktop PC.  It is only on my laptop.  

Your help would be appreciated.

Tom
0
Comment
Question by:ThomasJue
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 11
  • 8
19 Comments
 
LVL 50
ID: 37711723
Hello,

what do you see when you open the Paste Special dialogue? Copy something, then right click a target cell, select Paste Special.

Check File > Options > Advanced and make sure that all options in the section "Cut, copy and paste" are selected.

cheers, teylyn
0
 

Author Comment

by:ThomasJue
ID: 37711861
teylyn,

>>what do you see when you open the Paste Special dialogue? Copy something, then right click a target cell, select Paste Special.
[tom]  Only the icon "A" ("Keep Text Only") is showing.

Check File > Options > Advanced and make sure that all options in the section "Cut, copy and paste" are selected
[tom]  Yes, all boxes here are checked.

[tom} I opened this file from DropBox (www.dropbox.com) and thought that was presenting some sort of read-only problem.  

I then copied this file to my C drive, closed it and opened it and still have the same problem.  

Yet, when I open this file with my other computer and Excel 2010, I don't have this problem.
0
 
LVL 50
ID: 37711935
What happens with a new workbook. Can you see the complete paste options there?
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

Author Comment

by:ThomasJue
ID: 37711982
Teylyn

>>>What happens with a new workbook. Can you see the complete paste options there?

[tom]
I closed Excel complete. I did not reboot.  I then opened a new Excel workbook.
I inserted a formula and copied it.
On the paste option, again, only the "A" icon appears.

Sometimes when I re-boot, it works okay for a little while and then reverts back to this problem.

Tom
0
 
LVL 50
ID: 37712039
Do you have any add-ins loaded? Any files that load when Excel is started?

This is certainly not normal behaviour and it looks as if something is overriding Excel's default settings.
0
 

Author Comment

by:ThomasJue
ID: 37712078
>>>Do you have any add-ins loaded? Any files that load when Excel is started?

[tom]
I have a bunch of add-in's.  See atached file.  However, I added nothing new for about a month.
0
 
LVL 50
ID: 37712083
Nothing attached.

Suggest you disable all add-ins. Then see if the paste special options are back. Then enable one add-in after the other and check in between.

cheers, teylyn
0
 

Author Comment

by:ThomasJue
ID: 37712143
Excel Add-ins are now attached.

Now that I am reviewing it, I only have 3 active ones:  

QBExcelReportUpdater and QQube.

I will remove these.

Tom
Excel-Add-ins.pdf
0
 

Author Comment

by:ThomasJue
ID: 37712362
I removed the add-ins.  I closed and restarted Excel.  The problem is still there.  It won't paste formulas.

Tom
0
 
LVL 50
ID: 37712466
Try starting Excel in Safe Mode, as described  here http://support.microsoft.com/kb/280504#LetMeFixItMyselfAlways1

Click Start, and then click Run.
Click Browse, and then locate the folder where Microsoft Excel is installed, as specified earlier in this article.
After you locate the Excel.exe file, click the file to select it, and then click Open.
At the end of the path in the Open box, type a space and then type /s so that the entire line appears similar to the following:
"C:\Program Files\Microsoft Office\Office\Excel.exe" /s

This will open Excel without anything added in or running in the background.

If you still don't see the paste special options, then I'm really at a loss.
0
 
LVL 50
ID: 37712480
Here's what I see when I run in safe mode, copy a cell and use Alt - e - s to open the paste special dialogue.
screenshot
0
 

Author Comment

by:ThomasJue
ID: 37712543
>>Click Start, and then click Run.
My Windows 7 does not show a "Run" when click on Start.

Tom
0
 

Author Comment

by:ThomasJue
ID: 37712587
teylyn

I was poking around trying to do the "run".  I located the Excel.exe as you suggested.  I right clicked on it.  There was a "Run as administrator" option.  See the attached upload.  I tried this and it worked.  I can now paste formulas again.  Question is:
1.  Is this a good solution?
2.  How do I get it to run as admnistrator all the time as the default?

Tom
0
 

Author Comment

by:ThomasJue
ID: 37712835
teylyn,

The "Run as administrator" option only worked for a while and then the pasting as values took over again, leaving me no other options.  

I am now working on the "Compatibility Mode".  I changed it from "Windows 7" to "Windows XP (Service Pak 3)".  It seems to be working for now.

My other PC which is running Windows 7, Excel 2010 fine,  is running as  "Windows XP (Service Pak 3)".  However, I do not recall changing  my HP Laptop  when I began to experience this problem.  My HP Laptop is Windows 7, Office 2010.

I will keep working on this and report my findings tomorrow morning.  

Tom
snap001849-Excel-Compatibility.pdf
0
 

Author Comment

by:ThomasJue
ID: 37716147
teylyn,

I have an Acronis backup of my C drive from late January 2011.  I keep my programs on the C drive and my data on other drives.  I just did a restore.  Everything seems to be working okay.  As a side note, I also have a Windows 7 Image as a secondary backup.

I suspect it may have to do with Windows 7 operating system that administers multi-sessions of Excel.  The only software I had added inbetween was Skype.  I'll run it for the rest of the day and report back.

Tom
0
 
LVL 50
ID: 37716744
Thanks for the update. It sure sounds more like a problem with the local setup rather than an Excel setting.
0
 

Author Comment

by:ThomasJue
ID: 37723214
teylyn,

I have been working with Excel all day.  I only had one instance this morning where the Ctl+V resulted in a value paste.  However, I did an immediate paste with a right click and all the options for pasting showed up ... whew!  

Due to the randomness of this problem.  I will keep this open for one more day before I close it.  Again, thank goodness for Acronis.  Thank you.

Tom
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 500 total points
ID: 37878933
Hello,

this problem has been reported all over the web. Skype is the culprit. The click to call add-in for web browsers were interfering with the MS Office paste options.

http://blogs.skype.com/garage/2012/04/skype_click_to_call_fix_for_of.html

cheers, teylyn
0
 

Author Closing Comment

by:ThomasJue
ID: 37878962
I do have Skype loaded on my laptop.  I did this right around the time I had this problem.  Thank you.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

738 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