Ad: Manage updates with the Download App
ie8 fix

Office & productivity software forum: Excel not copying formulas

by: bruceva1 February 12, 2009 2:26 PM PST

Like this

0 people like this thread

Staff pick

Excel not copying formulas

by bruceva1 - 2/12/09 2:26 PM

I had a problem today with Excel 2003(Win XP)not copying formulas. When I copied and pasted, I would get the results of the formula as it/they existed in the original cell(s) rather than the formula(s). I reloaded Excel at one point and that seemed to clear things up, but when I loaded a second workbook it repeated the non-copying behavior for the second....when I closed out of the second workbook, it behaved properly with the first workbook???

Does anyone have any idea what is going on? The Excel program has been on the computer for a long time..perhaps it's corrupted in some fashion?

Thanks, Bruce


Reply
Report offensive post
Email to friend

Strange. Nveer seen it.

by Kees Bakker Moderator - 2/13/09 12:00 AM

In Reply to: Excel not copying formulas by bruceva1

So just a few questions.

- You just do ctrl-c on the old cell and ctrl-v on the new cell?
- Does it work correctly in all NEW workbooks and incorrectly in (some) OLD ones? Or isn't it as simple as that?
- If you try Edit>Paste Special and choose 'formulas' or 'all', does it work?

Kees


Was this reply helpful? (0)   (1)

Staff pick

Reply
Report offensive post
Email to friend

Thanks...

by bruceva1 - 2/14/09 6:19 AM

In Reply to: Strange. Nveer seen it. by Kees Bakker Moderator

...just plain old cut and paste. The workbooks were old...likely created under an older version of Excel. I've just finished a fairly large new workbook with no problems. I'll try the paste special/formulas/all next time it acts up. The sheets are related to income tax so there will be plenty of opportunity for the problem to reoccur in the next few weeks.

Bruce


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

I'm having the same issue in Excel -- just started happening

by jpisano67 - 4/22/12 7:19 AM

In Reply to: Thanks... by bruceva1

Did you figure out the solution to your Excel problem with cutting and pasting? I have Excel 2003 and no matter what I do, if I hit Ctrl-C and Ctrl-V (or Cut and Paste from the menu), it always pastes the VALUE and not the formula.


Was this reply helpful? (1)   (0)

Staff pick

Reply
Report offensive post
Email to friend

I'm having the same problem

by mike422a - 4/26/12 10:39 PM

In Reply to: I'm having the same issue in Excel -- just started happening by jpisano67

In one spreadsheet, I do a copy (^C) of one cell containing a formula, and go to another cell, and do a paste (^V) and it copies the result of the formula calculation in the first cell, not the formula, which is the normal behavior. It's driving me nuts.

It's a big spreadsheet with a lot of forulas and a lot of sheets, so it would be very time-consuming to try to re-create it, to see if that solves the problem.

What's going on? HELP!


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

Problem solved!

by jpisano67 - 4/27/12 6:06 AM

In Reply to: I'm having the same problem by mike422a

After some additional research into this, apparently this will happen if you have Firefox (perhaps with the Skype plugin installed) running at the same time that you have Excel running. If you close Firefox, you will see that the cut and paste functionality works as it should!

Crazy!!

Joe P.


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

Excel problem still persists!

by mike422a - 4/27/12 12:38 PM

In Reply to: Problem solved! by jpisano67

Thanks. Interesting theory. I was excited for a minute. I do have Firefox, and I believe it has the Skype plugin. But it's not running right now, and I tried the Excel spreadsheet again. But, same thing!

Any other ideas?

Mike


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

Excel Problem

by phorack - 4/30/12 7:24 AM

In Reply to: Excel problem still persists! by mike422a

I am having the same issue! I cannot cut and paste formulas or copy worksheets as I did in the past. I do not have Firefox, but do have Skype. Thoughts??

Pam H.


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

Excel Copy & Paste not working for me either!

by jocatley - 6/6/12 7:44 PM

In Reply to: I'm having the same problem by mike422a

Hi Mike,

Have you resolved this issue yet?? I'm having the same problem.... I'm not using Firefox - I use Google Chrome, (have recently changed from Internet Explorer to that). I also have Skype so maybe have that Skype Plug-in problem but have no idea how to find out...!!!

I use spreadsheets on a daily basis with formulas and I have been finding that instead of copying and pasting a formula, I have to type it in every cell because the copy and paste only pastes the value as a constant. When I do a copy and paste special, I get a weird screen that asks about the Source, and I can select Unicode text or text!!

If you have a solution, please let me know as this is driving me nuts too!! happy

Jo


Was this reply helpful? (1)   (0)

Staff pick

Reply
Report offensive post
Email to friend

SORTED!!!

by jocatley - 6/6/12 9:36 PM

In Reply to: Excel Copy & Paste not working for me either! by jocatley

This issue has been sorted now! It was being caused by Skype click to call, for some weird reason. So I just un-installed the programme and started up Excel again and it was all back to normal! Yay!


Was this reply helpful? (1)   (0)

Staff pick

Reply
Report offensive post
Email to friend

Gmail Voicemail

by asowards - 1/2/13 9:06 AM

In Reply to: SORTED!!! by jocatley

I installed Gmail's voice mail, and this happened to me as well. Drove me nuts because some force of evil wasn't letting me uninstall the Gmail voicemail. I finally had to view hidden files, and "View Protected Operating System Files" with a lot of DON'T DO THAT WARNINGS, but that was the only was to delete the file.

At least I hope it worked. The situation was solved on Monday, but I haven't been in Excel today.

Anyway - it was a ridiculous waste of time, even though it apparently solved the problem in the end.


Was this reply helpful? (0)   (0)

Staff pick

Reply
Report offensive post
Email to friend

More Discussions

Forum Icon Legend

  • UnreadUnread
  • ReadRead
  • Locked threadLocked thread
  •   
  •   
  •   
  •   
  •   
  •   
  •   
  • ModeratorModerator
  • CNET StaffCNET Staff
  • Samsung StaffSamsung Staff
  • Norton Authorized Support TeamNorton Authorized Support Team
  • AVG StaffAVG Staff
  • avast! Staffavast! Staff
  • Webroot Support TeamWebroot Support Team
  • Acer Customer Experience TeamAcer Customer Experience Team
  • Windows Outreach TeamWindows Outreach Team
  • DISH staffDISH staff
  • Dell StaffDell Staff
  • Intel StaffIntel Staff
  • QuestionQuestion
  • Resolved questionResolved question
  • General discussionGeneral discussion
  • TipTip
  • Alert or warningAlert or warning
  • PraisePraise
  • RantRant

You are e-mailing the following post: Post Subject

Your e-mail address is used only to let the recipient know who sent the e-mail and in case of transmission error. Neither your address nor the recipient's address will be used for any other purpose.

Sorry, there was a problem emailing this post. Please try again.

Submit Email Cancel

Thank you. Sent email to

Close

Thank you. Sent email to

Close

You are reporting the following post: Post Subject

If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.

Offensive: Sexually explicit or offensive language

Spam: Advertisements or commercial links

Disruptive posting: Flaming or offending other users

Illegal activities: Promote cracked software, or other illegal content

Sorry, there was a problem submitting your post. Please try again.

Submit Report Cancel

Your message has been submitted and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.

Close

Your message has been submitted and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.

Close

You are posting a reply to: Post Subject

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to the CNET Forums policies for details. All submitted content is subject to CBS Interactive Site Terms of Use.

You are currently tracking this discussion. Click here to manage your tracked discussions.

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Sorry, there was a problem submitting your post. Please try again.

Sorry, there was a problem generating the preview. Please try again.

Duplicate posts are not allowed in the forums. Please edit your post and submit again.

Submit Reply Preview Cancel

Thank you, , your post has been submitted.

> Click here to view your post. > Manage your tracked discussions. > Track this discussion. Close

Thank you, , your post has been submitted and will appear on our site shortly.

Close