Solved

Excel 2010 will not paste formulas

Posted on 2012-03-12
19
1,458 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
  • 11
  • 8
19 Comments
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
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

Expert Comment

by:Ingeborg Hawighorst
ID: 37711935
What happens with a new workbook. Can you see the complete paste options there?
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 

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

Expert Comment

by:Ingeborg Hawighorst
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

Expert Comment

by:Ingeborg Hawighorst
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

Expert Comment

by:Ingeborg Hawighorst
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

Expert Comment

by:Ingeborg Hawighorst
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

Expert Comment

by:Ingeborg Hawighorst
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 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

776 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