HI Sheila,

Do look at Bob's suggestion

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sheila" wrote in message ...
| 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
|