Could be you have a Change-event macro that is re-setting the Reference Style
.....
Try starting the file with macros disabled......then change it back and see
if it automatically re-changes again.

Vaya con Dios,
Chuck, CABGx3



"Nargile" wrote:


Hei guys.

I'm currently helping a friend of mine setting up some spreadsheets,
and something weird has started to happen. We now have 7 different
spreadsheet, which all automatically changes to R1C1-format. We started
with one, and trying to make it a bit easier on the eye, we cut'n'pasted
some stuff around and changed the formulas accordingly(all formulas are
simple SUMs of 3 or 4 other cells)
Suddenly, whenever we copy or move a cell to another, the spreadsheet
automatically switches to R1C1-format and all formulas change. That was
only the one, and the other ones were working fine, until we copied a
cell(a number) from one spreadsheet to another, and then the other one
suddenly changed aswell.. So after moving stuff back and forth to have
the setup of sheets we(he) wanted etc we now have 7 sheets with the
same disease.. I know how to switch off R1C1, and we do, but as soon as
anything is changed/added/removed in the spreadsheet, it jumps back to
running R1C1..

Any ideas would be much appreciated!


--
Nargile
------------------------------------------------------------------------
Nargile's Profile: http://www.excelforum.com/member.php...o&userid=35488
View this thread: http://www.excelforum.com/showthread...hreadid=552611