I've had that problem only in 2007 when programmatically manipulating
workbooks, workbooks that when opened manually worked in A1. Some workbooks
were 2003 format xls files, some were 2003 0r 2007 Excel files with
different extensions (i.e., not .xls*). I never got to the bottom of it, but
resorted to a line of code resetting the reference style after opening the
workbooks.
Excel 2007 doesn't really like Excel workbooks with different extensions,
FWIW.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Yasaf Burshan" wrote in message
...
Hello,
I have excel 2007 running on XPSP2.
I can't cancel the r1f1 reference style (whenever I re-open excel its
turned
on again).
How can I resolve this issue?
Thanks.
--
Yasaf Burshan