Formulas mutating

GeorgeB

Board Regular
Joined
Feb 16, 2002
Messages
239
Anyone ever had a problem with cell formulas mutating spontaneously when a workbook is copied ??
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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...
 
Upvote 0
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!!
 
Upvote 0
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

:)
 
Upvote 0
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 ?
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,560
Latest member
Torchwood72

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top