Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Formulas mutating

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Anyone ever had a problem with cell formulas mutating spontaneously when a workbook is copied ??
    George

    Learn to listen. Opportunity sometimes knocks very softly.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    North Alabama, USA
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well no I don't think so? Could you give a more detailed example of what you are refering to? Like a before and after.

    Rocky...

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This
    =ROUND((SUM(D227:G227)*C227)-H227,2)

    Changed to this
    =ROUND((SUM(D227:H227)*C227)-H227,2)

    all by itself when copied. it did it on 2 occasions that we know of and on 2 different computers. Both are drawing from a common server. wierd!!
    George

    Learn to listen. Opportunity sometimes knocks very softly.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    when you say "copied", how do you mean ?

    not like I know the answer, am just curious.

    Was it copied via File Manager or copied via file open / save as / new location ?

    Please repost if you figure it out, I'd like to knwo the answer to this one


  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    also...

    hee hee

    the 2 different computers, were they both copied to from the same scource computer ?

    same excel versions throughout ? same OS throughout ?

    also , not that it probably makes much difference, are any of those cells in the SUM range "merged" at all ?

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Copied Save As new location and then the sheet itself was copied in the workbook. The original sheet was OK but the copied sheet was mutated in 4 cells. This was on my computer. My cellmate did the same but had different cells mutate. Both copied from the same server and the same template. Same Excel version, same OS (Windows 98) and none of the cells were merged.
    Never seen anything like it. We have UPSís on both machines.

    George

    Learn to listen. Opportunity sometimes knocks very softly.

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    what was the exact name of the sheet ?

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mine was "Bldg 2". The other was something different.

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hmmm

    not a "reserved" name then....

    SOrry George, I know this isn't helping much !

    if it's not particularly sensitive data, can you email me a copy, I'd be interested to see if it does it on our network also....

    Chris


    novulari@hotmail.com

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    My employer would take a dim view of that.
    It seemed to be a completely random occurance and we have not been able to duplicate it. Just trying to do a little research on the problem. So far no one else seems to have encountered this "bug" if indeed it is a bug.
    George

    Learn to listen. Opportunity sometimes knocks very softly.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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