+ Post New Thread
Results 1 to 9 of 9
Office Software Thread, Excel 2003 - formala fill / paste problem in Technical; One of our bursary staff has a weird problem that I've not seen before. She is using a spreadsheet with ...
  1. #1
    Number6's Avatar
    Join Date
    Feb 2009
    Location
    Worcester, UK
    Posts
    457
    Thank Post
    2
    Thanked 9 Times in 8 Posts
    Rep Power
    13

    Excel 2003 - formala fill / paste problem

    One of our bursary staff has a weird problem that I've not seen before. She is using a spreadsheet with a simple summation formula in one cell, it's just adding up cells to the left. If she copies and pastes the cell content to another cell, or if she fills a range of cells then the new cells display the result of the cell copied from instead of what it should be. The summation ranges in the cells copied to are correct and if the formula is manually typed into a new cell it's fine.

    Anyone seen this before?

  2. #2
    danrhodes's Avatar
    Join Date
    Sep 2008
    Location
    Wath Upon Dearne
    Posts
    1,513
    Thank Post
    157
    Thanked 181 Times in 150 Posts
    Rep Power
    68
    You've confused me!

  3. #3
    linkazoid's Avatar
    Join Date
    May 2007
    Location
    London
    Posts
    654
    Thank Post
    121
    Thanked 90 Times in 74 Posts
    Rep Power
    79
    /\ /\ /\ /\ /\ /\ /\ /\ As previous poster said /\ /\ /\ /\ /\ /\ /\ /\

    Try Paste Special Values only...

    Michael

  4. #4
    echo's Avatar
    Join Date
    Aug 2009
    Posts
    16
    Thank Post
    4
    Thanked 4 Times in 4 Posts
    Rep Power
    13
    Sounds like it's not recalculating the formula to me. Go to tools > options > calculation and check automatic is selected.

    We find that sometimes it is set to manual by default.

  5. #5
    danrhodes's Avatar
    Join Date
    Sep 2008
    Location
    Wath Upon Dearne
    Posts
    1,513
    Thank Post
    157
    Thanked 181 Times in 150 Posts
    Rep Power
    68
    Quote Originally Posted by echo View Post
    Sounds like it's not recalculating the formula to me. Go to tools > options > calculation and check automatic is selected.

    We find that sometimes it is set to manual by default.
    Or just press f7 i think!

  6. #6
    Number6's Avatar
    Join Date
    Feb 2009
    Location
    Worcester, UK
    Posts
    457
    Thank Post
    2
    Thanked 9 Times in 8 Posts
    Rep Power
    13
    Quote Originally Posted by danrhodes View Post
    You've confused me!
    Quote Originally Posted by linkazoid View Post
    /\ /\ /\ /\ /\ /\ /\ /\ As previous poster said /\ /\ /\ /\ /\ /\ /\ /\

    Try Paste Special Values only...

    Michael
    Tried all the paste options with no success.

  7. #7
    Number6's Avatar
    Join Date
    Feb 2009
    Location
    Worcester, UK
    Posts
    457
    Thank Post
    2
    Thanked 9 Times in 8 Posts
    Rep Power
    13
    Quote Originally Posted by echo View Post
    Sounds like it's not recalculating the formula to me. Go to tools > options > calculation and check automatic is selected.

    We find that sometimes it is set to manual by default.
    I'll try that one, thanks.

  8. #8

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    271
    Thank Post
    25
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    Press f9 to recalculate will sometimes fix it

  9. #9
    Number6's Avatar
    Join Date
    Feb 2009
    Location
    Worcester, UK
    Posts
    457
    Thank Post
    2
    Thanked 9 Times in 8 Posts
    Rep Power
    13
    Quote Originally Posted by echo View Post
    Sounds like it's not recalculating the formula to me. Go to tools > options > calculation and check automatic is selected.

    We find that sometimes it is set to manual by default.
    Thanks everyone, it was this one.

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2007] MS Access Bizarre Paste Problem
    By RabbieBurns in forum Office Software
    Replies: 1
    Last Post: 23rd February 2009, 11:39 AM
  2. Excel 2003 problem with chart...
    By kennysarmy in forum Windows
    Replies: 6
    Last Post: 12th December 2008, 07:04 PM
  3. Replies: 2
    Last Post: 4th December 2008, 11:23 AM
  4. fill web form from excel
    By RabbieBurns in forum How do you do....it?
    Replies: 0
    Last Post: 8th October 2008, 01:17 PM
  5. Cut and paste issues between excel and word
    By 17thcpikeman in forum Windows
    Replies: 1
    Last Post: 30th November 2007, 01:42 PM

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
  •