Solved

can not copy  and paste formulas

Posted on 2012-03-30
15
383 Views
Last Modified: 2012-04-02
Hi,

  I am now not able to copy and paste formulas,  instead it copies the value of the cell, not the formula when i try to copy into another cell.  Is just a simple SUM formula.

  Any help ?
0
Comment
Question by:joe_echavarria
[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
  • 7
  • 3
  • 2
  • +3
15 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 37788957
Are you copying the formulas between two different workbooks? Might each workbook be opened in a separate instance of Excel?

Kevin
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37788959
during paste.. right click and select paste special... select formula from the shortcut menu.
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 37788970
Are you using shortcut keys to copy and paste?  If so, is it possible that the [Ctrl]+[V] combination (paste) now accesses a macro?

Have you tried using the Excel menu (either directly or by right-clicking and using a shortcut menu) to paste?

-Glenn
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 1

Author Comment

by:joe_echavarria
ID: 37788989
Is in the same WorkSheet.

During the paste and i click on paste special. i can not see " formula " in the shortcut menu.
When the "past special" option is clicked a screen shows only "Paste as -Unicode Text- and -Text- " options.  and in both cases only paste the value of the field, not the formula.

I have also tried using Excel menu directly.

Any other tip ?
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37788999
you are copying the content of the cell by selecting the text.

just click ones the cell and copy.. then do the paste special
0
 
LVL 16

Expert Comment

by:l33tf0b
ID: 37789042
Is this for all spreadsheets on this machine as well as for all users on this machine?

You could try having excel launch for the first time by blowing out the reg key here:

start > run > regedit

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel

Delete the folder.  Substitute 11.0 with the Office version you have (i'm using 2003 here)

launch excel again.
0
 
LVL 1

Author Comment

by:joe_echavarria
ID: 37789048
When you try to copy a cell you get the cell cover with "dots lines"  which means that you are about to copy the cell formula or contents,  but in my case i do not get it like that.    The "dot lines" cover of the cell is not when i try copy the cell.

Any tip ?
0
 
LVL 1

Author Comment

by:joe_echavarria
ID: 37789063
Yes it is with any spreadsheets on this machine.
0
 
LVL 1

Author Comment

by:joe_echavarria
ID: 37789091
It is Excel 2010
0
 
LVL 16

Expert Comment

by:l33tf0b
ID: 37789128
Remove the folder below from regedit.

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel
0
 
LVL 1

Author Comment

by:joe_echavarria
ID: 37789175
I just removed the folder, and still have the same problem.

do i have to create the registry entry again ?, i just delete it.
0
 
LVL 16

Expert Comment

by:l33tf0b
ID: 37789248
no, just delete it.  Next time you start Excel, it should have went through what looks like an install of it.  Did that come up?
0
 
LVL 1

Author Comment

by:joe_echavarria
ID: 37789256
it seems to be normal,   the "recent" documents were lost.  I had to open each file directly and browse it in the computer.

still has the same problem.  Also when you try copy a cell , the " dot lines " that cover the cell does not appears.

Still have the same problem.
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 37795659
Do you have Skype Click to Call plug in installed in your browser? There seems to be a bug with the current version that messes up pasting in Office 2010. Usually, either uninstalling it or having all browsers closed seems to fix it. See post here: http://www.thecodecage.com/forumz/hot-topics/212321-paste-paste-special-issues-office.html
0
 
LVL 1

Author Closing Comment

by:joe_echavarria
ID: 37799230
I just had the Skype to Call plug in uninstalled and it worked.

Thanks !!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

732 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