Formulas mutating

GeorgeB · Apr 29th, 2002, 11:50 AM

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

Rocky E · Apr 29th, 2002, 11:56 AM

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...

GeorgeB · Apr 29th, 2002, 12:20 PM

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!!

Chris Davison · Apr 29th, 2002, 02:05 PM

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

Chris Davison · Apr 29th, 2002, 02:09 PM

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 ?

GeorgeB · Apr 29th, 2002, 08:58 PM

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.

Chris Davison · Apr 29th, 2002, 10:17 PM

what was the exact name of the sheet ?

GeorgeB · Apr 30th, 2002, 10:00 AM

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

Chris Davison · Apr 30th, 2002, 04:17 PM

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

GeorgeB · Apr 30th, 2002, 08:16 PM

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.

Apr 29th, 2002, 11:50 AM	#1
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	Anyone ever had a problem with cell formulas mutating spontaneously when a workbook is copied ?? __________________ George Learn to listen. Opportunity sometimes knocks very softly.

Apr 29th, 2002, 12:20 PM	#3
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	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.

Apr 29th, 2002, 08:58 PM	#6
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	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.

Apr 30th, 2002, 08:16 PM	#10
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 11:56 AM	#2
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	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...

Apr 29th, 2002, 02:05 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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

Apr 29th, 2002, 02:09 PM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ?

Apr 29th, 2002, 10:17 PM	#7
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	what was the exact name of the sheet ?

Apr 30th, 2002, 10:00 AM	#8
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	Mine was "Bldg 2". The other was something different.

Apr 30th, 2002, 04:17 PM	#9
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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