This setting is local to the running instance of excel--user by user.

In xl2003 menus:
Tools|Options|General tab|Uncheck R1C1 Reference style.

Excel picks up this setting from the first workbook the user opens in that
session.

If you have a co-worker who likes R1C1 Reference Style and you're unlucky enough
to open a workbook that he saved as the first workbook in that session, you'll
be making the same change again.


Joe Ambrose wrote:

I have a user (several actually) that have reported peculiar behavior
in Excel 2003.

If 2 users open the same spreadsheet (network share) the first user
will get the sheet with the R1C1 option turned off ( Columns are
A,B,C.. ) the second user will get the sheet (after receiving the File
in Use message, ( user clicks on the Read Only option) and the R1C1
option is enabled ( Columns are 1,2,3. )

If user 1 sends me a copy of the sheet via email and I open it, the
columns are fine.

Copied the network version of the sheet onto my desktop (renamed it
..-1.xls) and saved his attachment to my desktop (renamed it
..-2.xls)

Opened ..-1 the columns are 1,2,3..
Closed Excel

Opened .-2 the columns are A,B,C..

It seems that the option was saved with the sheet (-1) and not with
(-2)

This is perplexing on a Monday morning!!! Has anyone seen this
behavior before???

System Info.

WXP Pro SP 2
MSO Excel 2003 (11.8307.8221) SP3

If you need more information, please respond to my email address.

Joe Ambrose
LS Power Group, LLC
Joey11701-at- gmail -dot- com

--

Dave Peterson