Reply to thread

Message: [QUOTE="Niek Otten, post: 9768094"] HI Sheila, Do look at Bob's suggestion -- Kind regards, Niek Otten Microsoft MVP - Excel | Hi Dave | | Thankx for the reply but I'm still battling. I had this problem on Office | 2003 and after completely un-installing that version and then doing a brand | new install of Office 2007 beta release 2, I have the same problem. This | kinda tells me that this setting is held in some kind of profile file or such | like 'cos like I say I completely un-installed Office 2003. | | I am the only user of these worksheets as I'm saving them on my own laptop. | If I just launch Excel and do nothing else other than change that setting | and then close out of Excel I stil have the problem when I come back in. | | I appreciate your suggestions. | Thankx | Sheila | | | | "Dave Peterson" wrote: | | > Excel picks up this setting from the first workbook you open in that session. | > If you're unlucky enough that your first workbook opened is in R1C1 reference | > style, you'll have to make the change. | > | > Do you save the workbook after you make the change to A1 reference style? | > | > Do you have a coworker who likes R1C1 and saves it that way? (Could mean a | > fight!) | > | > Sheila wrote: | > > | > > Despite changing the setting under Options/General where I uncheck the box | > > "R1C1" every time I open Excel, it does not seem to store my setting | > > permanently. How can I permanently undo this setting so that I work in "A1" | > > mode? | > > | > > Thankx | > > Sheila | > > | > | > -- | > | > Dave Peterson | > [/QUOTE]

Verification