+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 27 of 27
Office Software Thread, Excel Formula Copy Problem in Technical; Right click and copy and paste it into the formula bar then press ALT & Enter....
  1. #16

    Join Date
    Oct 2008
    Location
    Lincolnshire
    Posts
    2,228
    Thank Post
    13
    Thanked 230 Times in 219 Posts
    Rep Power
    68
    Right click and copy and paste it into the formula bar then press ALT & Enter.

  2. #17

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,213
    Thank Post
    372
    Thanked 379 Times in 337 Posts
    Rep Power
    148
    I've seen this happen randomly to quite a few users using Office 2007

  3. #18
    bpd
    bpd is offline

    Join Date
    Sep 2010
    Location
    Washington, DC
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I'm glad to hear it's not just me. Is there a known fix for this?

  4. #19

    Join Date
    Mar 2012
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I am having the same issue. When I try to use cntr-c or any copy function, what is coped is only coied as the visual text or values. If I reboot, the spreadsheet is fine for some perior of time, but after another 20-30 minutes at work, the copy funtion stops working. Quite frustration with no apparent trigger.

  5. #20

    Join Date
    Mar 2012
    Location
    United States
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    I think I found the solution!

    Quote Originally Posted by givings View Post
    I am having the same issue. When I try to use cntr-c or any copy function, what is coped is only coied as the visual text or values. If I reboot, the spreadsheet is fine for some perior of time, but after another 20-30 minutes at work, the copy funtion stops working. Quite frustration with no apparent trigger.
    I only just started having this EXACT same issue. Our IT couldn't even figure it out, and then by accident I think I found out the cause.
    Apparently it seems like Google Chrome is conflicting with Microsoft Excel 2003. It's only recent too; but if I have Google Chrome running it won't copy and past formulas and won't even allow me to right click a cell and choose the way I want to paste, normally.
    BUT as soon as I shut down Chrome - BAM! It works normally again. So if you're also running chrome it may be the cause of your problems too. If not, I would try running XL with no other programs running and then see what happens. If it works I would then start running adiditonal programs you usually have running in the background to find out what triggers your issue.

    Good luck!

    ETA: I was just going to post the issue on the Google message board and did a quick search for "Excel" and found a bunch of peiople having the same issue. A Google tech replied and said that yif you have Skype "Click to call" installed it's what's causing the issue, so you need to uninstall it and then everything goes back to normal and you can run Chrome and Excel at the same time.
    Last edited by Stazi; 28th March 2012 at 09:05 PM. Reason: Additional info

  6. #21

    Join Date
    Apr 2012
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I faced the same situation and I solved unistalling the Skype Click to Call! It is weird, but works!

  7. #22

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    Quote Originally Posted by SYNACK View Post
    Does it have all the service packs, their up to three now, perhaps it was a bug Download details: Office 2000 Update: Service Pack 3 (SP3)
    Technically Office 2000 is unsupported now, although it was a pain in the rear to patch. You needed Service Release 1 or 1a then Service Pack 3 was possible.

    Thankfully Microsoft have simplified patching with Office 2007 and Office 2010 where you literally drag/drop files into the Updates folder.

  8. #23

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,224
    Thank Post
    874
    Thanked 2,717 Times in 2,302 Posts
    Blog Entries
    11
    Rep Power
    780
    Quote Originally Posted by Michael View Post
    Technically Office 2000 is unsupported now, although it was a pain in the rear to patch. You needed Service Release 1 or 1a then Service Pack 3 was possible.

    Thankfully Microsoft have simplified patching with Office 2007 and Office 2010 where you literally drag/drop files into the Updates folder.
    Wow, this is an old one and so is Office 2000.

    I liked the old patching method much better, you could slipstream them so you only installed it once with all the patches. The new method is insane and retarded, you install it then it systematicly spends the next two hours installing over that install with all the updates in the folder one at a time. It is stupid and a step backwards efficiency wise. That is why Office is now pushed out in our base image with all the updates already installed like any other silly unpatchable downlevel bit of cruft would be.

    Other than that I find the newer versions of Office really good but the update situation irritates me hugely, just like the Windows Vista onwards lack of slipstreaming, you just have to download the SP integrated versions from MVLS if they eventually release them.

  9. #24

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    You could argue the footprint of Office 2007 and Office 2010 is bigger than Office 2000/2003 anyway, so it will always take longer.

    Like yourself, I include all applications on a master image and there's only been approx. 20 hotfixes post Office 2010 SP1.

  10. #25

    Join Date
    May 2012
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by sqdge View Post
    One of the teachers at my school is having a problem with Excel that has flumoxed me and everyone else who has attempted to help.

    She has put in a very simple formula (=A1+B1) which calculates fine. However when she then copies the formula down the column, the formula changes with it ok (e.g. =A2+B2, =A3+B3, =A4+B4 etc.) but it merely copies the answer from the first cell instead of running the formula.

    I'm sure this is really easy to solve, which is where you lot come in....!
    Easy fix... Close all web browsers, then rerun excel and it will work. The issue is with a skype browser add-in. I had the same problem this morning. Disabling the add-in in browsers will also allow excel to work.

  11. #26

    Join Date
    Nov 2012
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Issue with Copy and Paste Formula displaying correct formula but answer to copied cel

    Go to Calculation Options
    Change to Automatic.

    Sometimes this changes to manual, which presents the error expeirenced. Sometimes it defaults. It's annoying.

    Done...

  12. #27

    Join Date
    Feb 2013
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by limbo View Post
    If she presses f9 does it then display correctly?

    If so then she has switched of automatic calculation - look in tools > options > calculation tab > tick the automatic option
    In the Mac version of Excel (14.x.x) you will find the calculation tab under Preferences. There you can turn on the automatic option and it will fix the problem.

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Strange Excel Problem
    By Jon in forum Windows
    Replies: 14
    Last Post: 14th July 2011, 04:55 PM
  2. Excel sum problem
    By wesleyw in forum How do you do....it?
    Replies: 8
    Last Post: 29th August 2009, 11:23 AM
  3. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM
  4. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 10:08 PM
  5. Bizzare Excel Problem
    By Norphy in forum Windows
    Replies: 3
    Last Post: 17th January 2006, 10:19 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •