You opened in safe mode and still had the trouble.
Save a new workbook in A1 reference style.
Close excel.
reopen excel in safe mode.
Is that initial workbook shown in A1 or R1C1 reference style.
If it's A1, then try opening the test workbook that you just saved. Is excel
still in A1 reference style?
Excel picks this up from the first workbook you open in that session. Maybe
it's your personal.xls workbook--or an addin.
You sure you followed Chip/Jan Karel's instructions when you were checking
things out??
Nargile wrote:
Hmm.. Ok I tried everything i could find on bugs etc, and the tips and
links you gave me, but nothing. No matter how I open the file, it still
changes back to R1C1-style as soon as anything is changed in the file.
--
Nargile
------------------------------------------------------------------------
Nargile's Profile: http://www.excelforum.com/member.php...o&userid=35488
View this thread: http://www.excelforum.com/showthread...hreadid=552611
--
Dave Peterson