Peculiar Excel behavior

J

Joseph Ambrose

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pecuilar Excel behavior 5
Relevant user should see only his data 0
Copy columns and paste with blank column between 5
Need to create an excel template with many dependencies between columns and some prog 0
Code works but goes into endless loop and crashes 1
Modify working code to expand the output. 5
Sum of Variable Cells in a fixed Row 3
Conditional Validation In Excel 1

Top