If you've opened a workbook before the current book, it will retain the prior
workbook's setting. So if both users have workbooks open with different
views, subsequent files will retain the prior views, regardless how the files
were opened. At that point, it becomes a user-level setting, not file-level.
Hope this helps!

"Joe Ambrose" wrote:

Dave,

This i understand, but if you read my post a little closer....

User A opens the sheet and uses the ABC reference style...... While user A
has the sheet open.....
User B opens the SAME Sheet and recieves the "File In Use" message and
clicks on Read only to open the sheet.
Excel opens in the R1C1 reference style.

It SHOULD open in the "ABC" style. shoud it not?


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


.