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 ??
 
George, that would be a case of "user error." That would not happen if no one purposely changed the formula or VBA code manipulated the spreadsheet. Copying files doesn't change "formulas" in spreadsheets.
 
Upvote 0

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
I would agree, however, for two experienced users to make the same error on different work stations seems very unlikely.
 
Upvote 0
George,

this has had me intrigued for a couple of nights now.... hence my request to actually see the workbook...

(*memo to myself to actually GET a life...*)

can I ask that if you ever track down what was causing it, to post back to this board with what was wrong ?

cheers
Chris
:)
 
Upvote 0
Chris
Thanks for your interest. We have not been able to either duplicate it or find the cause. The only possibility we can think of is a power variation during copy or save to the network. Why that would cause a mutation of formulas in random cells is beyond me.
This message was edited by GeorgeB on 2002-05-02 06:54
 
Upvote 0

Forum statistics

Threads
1,215,133
Messages
6,123,235
Members
449,092
Latest member
SCleaveland

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